Duplicate guids for McAfee in Kace report
I have a number of machines that have duplicate guids for their McAfee Agent. I've made a custom inventory rule but I want to group the guid and count them up so I can find the duplicate guids and run a script fix on those machines. Is report that can do this? I'm trying to figure out how to do this but I'm grasping at straws at the moment.
Community Chosen Answer
I've gotten the code to generate the report however it shows groups that have one etnry, I'd like to get rid of those and only show groups that have more then one entry. Here's my sql
SELECT IP,MAC,MACHINE.NAME AS SYSTEM_NAME,(SELECT MACHINE_CUSTOM_INVENTORY.STR_FIELD_VALUE FROM MACHINE_CUSTOM_INVENTORY WHERE MACHINE_CUSTOM_INVENTORY.ID=MACHINE.ID AND MACHINE_CUSTOM_INVENTORY.SOFTWARE_ID=44226) AS MACHINE_CUSTOM_INVENTORY_0_44226,(SELECT MACHINE_CUSTOM_INVENTORY.STR_FIELD_VALUE FROM MACHINE_CUSTOM_INVENTORY WHERE MACHINE_CUSTOM_INVENTORY.ID=MACHINE.ID AND MACHINE_CUSTOM_INVENTORY.SOFTWARE_ID=43613) AS MACHINE_CUSTOM_INVENTORY_0_43613 FROM MACHINE WHERE ((1 in (select 1 from MACHINE_CUSTOM_INVENTORY where MACHINE.ID = MACHINE_CUSTOM_INVENTORY.ID and MACHINE_CUSTOM_INVENTORY.SOFTWARE_ID = 44226 and MACHINE_CUSTOM_INVENTORY.STR_FIELD_VALUE is not null)) ) ORDER BY MACHINE_CUSTOM_INVENTORY_0_44226 desc