Need to know primary and/or assigned user of a computer
Hello everyone,
we have SMP 7.1 with ITMS suite installed.
We need to know which computer(s) a particular user has used.
The report that I lookup to get this information is the Primary User by computer" (Reports-->Discovery and Inventory-->Windows-->User-->Primary User-->Primary User by computer). But I noticed that this report does not contain a complete list of all the computers on the network. We setup our SMP around July of this year and when i searched for the month of September, for example, I still do not get a complete computer list.
I understand that a computer can have a "primary user" and an "assigned user". Is there task that runs to automatically set the primary user? I understand that the assigned user can be set manually but is there a task to set the primary user to be the assigned user automatically?
I would also like to be able to search on a user name and know which computers that they have logged into.
Thank you in advance for your assistance
regards
efyuze
Comments 2 Comments • Jump to latest comment
A very easy way is using the logon / logoff records or the already created report for 'users profiles across multiple machines' (Reports-->Discovery and Inventory-->Windows-->User-->) that should be inventoried.
If not all machines are showing up in the report you talked about i beleive the filter for that report is machines with inventory. This would possibly point that some of the machines aren't reporting back with inventory information. I got around this problem by creating a filter for machines that dont have an inventory and then forcing a task to run a full inventory on the machines that are in that filter.
For a simple Logon Logoff list you can use: %LOUSERNAME% is a parameter i setup so i can easily search for specific users.
SELECT cid.[Name] Computer ,(LO.[Domain] + '\' + LO.[User]) [User] ,LO.[Login Time] ,LO.[Time] [Logout Time] ,CONVERT(decimal(10,2),ROUND((LO.[Duration]/60.0),2)) [Duration In Hours] ,LO.[Duration] FROM [Altiris_CMDB7].[dbo].[Evt_AeX_Client_LogOn] LO JOIN Inv_AeX_AC_Identification cid ON cid._ResourceGuid = LO._ResourceGuid WHERE [User] LIKE '%LOUSERNAME%' AND [LO].[Event] = 'Logoff' ORDER BY LO.[Login Time] DESCRegards Jim.
Connect Etiquette: "Mark as Solution" those posts which resolve your problem and give a thumbs up to useful comments, articles and downloads.
hi Jim,
Thanks for your reply! I will will have a look at this
regards
Would you like to reply?
Login or Register to post your comment.