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 Comments
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.
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 ?
That is very fascinating, You are a very skilled blogger. I've joined your rss feed and sit up for in search of extra of your fantastic post. Additionally, I've shared your web site in my social networks
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.