Roger Zander at myITforum.com

Multiple entries for TopConsoleUser

I have seen an Environment where the Table SYSTEM_CONSOLE_USAGE_DATA had multiple entries per device… with the result that the TopConsoleUser was an old,orphaned entry on some reports.

The following Query will return all affected Machines:

SELECT COUNT(*) as [Count], System_DISC.Netbios_Name0, SYSTEM_CONSOLE_USAGE_DATA.MachineID 
FROM SYSTEM_CONSOLE_USAGE_DATA INNER JOIN 
     System_DISC ON SYSTEM_CONSOLE_USAGE_DATA.MachineID = System_DISC.ItemKey 
GROUP BY System_DISC.Netbios_Name0, SYSTEM_CONSOLE_USAGE_DATA.MachineID 
HAVING COUNT(*) > 1 

A full Hardware Inventory cycle removed the duplicates. You can use Collection Commander to enforce a full HW Inventory on the affected clients…

Posted: Mar 21 2013, 12:03 PM by rzander | with no comments
Filed under:

Comments

No Comments