Client Management Suite

Did Altiris has that kind of info that how manytime of people login to each PC?

Example: For each of the 50 machines how many people log into it every day.

Thanks

Lillian

If Resource Data History has been enabled for the basic inventory login table, then yes. 

History tables start with "invhist_"

Have you tried the inv_aex_ac_machine_usage table?

Hi Lillian,

Everytime you forget which table you should query in Altiris, you can check out Resource Manager > View. There you can find all data classes related.

Per your request, I guess the events table will help you better. Check below:

Hope this helps.

Regards.

Here is a link with attached xml, where you can find a report about last user logon/logoff

• https://support.symantec.com/en_US/article.TECH227522.html

You can import this attached xml and then delete all unnecessary report and leave only required report.

Thanks,

IP.

This is what we've used a long time.  You can unremark the computer or user lines to suit your needs;

SELECT     
Inv_AeX_AC_Identification.Name,    
Evt_AeX_Client_LogOn.[Domain],
Evt_AeX_Client_LogOn.[User],
Evt_AeX_Client_LogOn.[Event],
Evt_AeX_Client_LogOn.[Time] as [Date and Time]  

FROM
vComputer INNER
JOIN Evt_AeX_Client_LogOn ON vComputer.Guid = Evt_AeX_Client_LogOn._ResourceGuid LEFT OUTER
JOIN Inv_AeX_AC_Identification ON vComputer.Guid = Inv_AeX_AC_Identification._ResourceGuid   

WHERE

--(Inv_AeX_AC_Identification.Name LIKE '%computername%')
--Evt_AeX_Client_LogOn.[User] = '%userid%'

ORDER BY Evt_AeX_Client_LogOn.[Time] DESC