Computers with specific application installed with IPaddress. Additional reports for Add and remove programs are available from http://eskonr.com/2010/01/sccm-report-for-applications-installled-on-computers-with-without/ SELECT a.Name0,b.IPAddress0,c.DisplayName0…
Browsing: SQL Queries
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…
If you want to trace the users on what computers are they logged in(please be noted that this is based…
Create a new report and paste the following query into it.This needs prompt as well to list the applications installed…
This report gives you list of PCS where no user logged into the computer since 20 days.If the SCCM clients…
Do you want to find out the computers based on the user names where they have logged on lastly and to…
Below is the report to list computers with IP address and Subnet information from Given collection. select distinct A.Name0,c.IPAddress0…
When you assign any advertisement (either application or Task sequence) to collection(Group of computers) ,all the advertisement will be tracked(logged)…