SCCM report for Last logged on computer name with application installed or not

Do you want to find out the computers based on the user names where they have logged on lastly and to see if they have specific application is installed or not with date ?

Here you go with the SCCM report with list of users .

select a.Name0,a.UserName0 as 'Last logged in',c.DisplayName0,c.InstallDate0 from v_GS_COMPUTER_SYSTEM a ,
v_Add_Remove_Programs c where a.Username0 in ('domain\sccmadmin','domain\user1')  and a.ResourceID=c.ResourceID and c.DisplayName0  like '%Microsoft Office%'
order by name0

SCCM report to Display computers that users in a specific security group last logged in on to with software exist or not?

select a.Name0,a.UserName0 as 'Last logged in',b.Usergroup_Name0,c.DisplayName0,c.InstallDate0 from
v_GS_COMPUTER_SYSTEM a ,v_R_UserGroup b,v_Add_Remove_Programs c where b.Usergroup_Name0=@secgroup and
c.DisplayName0 like @application and a.ResourceID=c.ResourceID
order by name0

Prompt For secgroup:select Usergroup_Name0 from v_R_UserGroup

Prompt for application:select DisplayName0 from v_Add_Remove_Programs

4 Responses to "SCCM report for Last logged on computer name with application installed or not"

  1. hi, i am trying to run your report and get the follwing error. your help would be highly appreciated.

    [42000][102][Microsoft][ODBC SQL Server Driver][SQLServer]incorrect syntac near"".

    we are trying to get a report on application by last logged in username and computer name.

    1. please replace the fancy quotes with original quotes as the blog replaces them and try.
      can you please post your query what are you trying ?

  2. Thanks for every other informative web site. The place else may I am getting that kind of information written in such a perfect means? I have a project that I am just now running on, and I've been at the look out for such information.


Leave a Reply