Tags: last logged on user name

Posted on September 10, 2012 by | 2 Comments | 4,628 Views
Here is nice report to identify computers which are with more than one partition installed on to them excludes external drives. select CS.Name0 as [Computer name],        MAX(OU.System_OU_Name0)as [OU],        CS.UserName0 as [Last loggedon User],        FCM.Sitecode ,        OS.Caption0 AS [OS],        OS.InstallDate0 [OS Installed Date],        WS.LastHWScan [Recent Reported to sccm]      from …
Read more »

Posted on January 30, 2012 by | 13 Comments | 8,246 Views
long ago have posted report on computers with SCCM report for Last logged on computer name with application installed or not and SCCM report display computers with IPaddress based on Application/software this report gives you computers with ip address and last logged on username from a given collection : select A.Name0,c.IPAddress0 as 'IP ADDRESS',E.UserName0 as…
Read more »

Posted on March 28, 2011 by | 15 Comments | 19,574 Views
You have report to list all computers based on last logged on username from http://eskonr.com/2011/03/sccm-report-to-list-all-computers-based-on-last-logged-on-user-name-from-collection/ . In this post,you will get list of computers with last logged on user name from given collection. Create a new report and paste the below query into it. Select A.Name0, A.UserName0  from V_GS_COMPUTER_SYSTEM A join v_FullCollectionMembership B on A.ResourceID…
Read more »