Snapin membership not listing in web interface

[Wayne Workman]

Server

• FOG Version: 1.3.0 RC-14
• OS: CentOS 7 fully updated

Description

For a snapin that has been assigned to some or all hosts, the snapin membership lists no members.
Web Interface -> Snapin Management -> [click snapin] -> Membership

Doing some digging in the DB, the snapin is associated with many hosts:

MariaDB [fog]> select sID,sName from snapins;
+-----+--------------------------------+
| sID | sName                          |
+-----+--------------------------------+
|  12 | PB Meraki                      |
|  13 | iTunes 64-Bit                  |
|   2 | CK-Meraki                      |
|   3 | HF Meraki                      |
|   4 | Avast                          |
|   5 | PR Meraki                      |
|   6 | CL-Meraki                      |
|   7 | Chrome 51.0.2704.106           |
|   8 | BM Meraki                      |
|   9 | CK-PLTW-Office-Activation      |
|  10 | FMS-Meraki                     |
|   1 | LoggerPro_3.11                 |
|  19 | Doceri                         |
|  15 | Dameware-Update-MSI            |
|  28 | Gimp                           |
|  21 | SmartMusic                     |
|  11 | CV Meraki                      |
|  14 | LH-Meraki                      |
|  22 | Chrome-52.0.2743.116           |
|  23 | AI Meraki                      |
|  24 | Minecraft-Education-Edition-CK |
|  26 | Cleanup_Local_IP_Printers      |
|  27 | dmSecureBrowser1b              |
|  29 | CK-KITE-SSD                    |
|  30 | CC Meraki                      |
|  31 | PL Meraki                      |
|  32 | BE Meraki                      |
|  33 | CE Meraki                      |
|  34 | CO Meraki                      |
|  35 | DU Meraki                      |
|  36 | GR Meraki                      |
|  37 | HO Meraki                      |
|  38 | JW Meraki                      |
|  39 | RO Meraki                      |
|  40 | VO Meraki                      |
|  41 | WG Meraki                      |
|  42 | WE Meraki                      |
|  43 | MC Meraki                      |
|  44 | MB Meraki                      |
|  45 | MN Meraki                      |
|  46 | Adobe Reader DC                |
|  47 | CK-Insight-Ch12                |
+-----+--------------------------------+
42 rows in set (0.00 sec)

MariaDB [fog]> select * from snapinAssoc where saSnapinID = 26;
+------+----------+------------+
| saID | saHostID | saSnapinID |
+------+----------+------------+
| 6006 |        9 |         26 |
| 5939 |       11 |         26 |

two-thousand-ish lines later...

| 5976 |     2153 |         26 |
| 6008 |     2154 |         26 |
+------+----------+------------+
1960 rows in set (0.01 sec)

[Tom Elliott]

Fixed in latest, thanks for reporting. Had a dyslexic typo. Where it was grabbing was from ‘hosts’, but snapins were setting hsots accidentally.