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 FROM v_GS_ADD_REMOVE_PROGRAMS c, v_R_System a, v_GS_NETWORK_ADAPTER_CONFIGUR b WHERE a.ResourceID = b.ResourceID and a.ResourceID=c.ResourceID and b.IPEnabled0='1' and b.ipaddress0 !='0.0.0.0' AND c.DisplayName0 like '%Adobe acrobat%' GROUP BY a.Name0, c.DisplayName0, b.IPAddress0   ORDER BY a.name0 If there are…

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…

If you want to trace the users on what computers are they logged in(please be noted that  this is based on the hardware inventory information and if multiple users logged into same computer will not report to site server until inventory information sent). Take a look at this post for more information about explaining last logged…

Create a new report and paste the following query into it.This needs prompt as well to list the applications installed on computers . Select Distinct sys.Netbios_Name0, sys.User_Domain0, sys.User_Name0 FROM v_R_System sys JOIN v_Add_Remove_Programs arp ON sys.ResourceID = arp.ResourceID WHERE sys.ResourceID not in (select sys.ResourceID from v_R_System sys JOIN v_Add_Remove_Programs arp ON sys.ResourceID = arp.ResourceID where…

This report gives you list of PCS where no user logged into the computer since 20 days.If the SCCM clients has any issues in sending inventory information to site server,you will see lot of computers though user logged into the computer. select a.Name0,a.UserName0,TimeStamp from v_GS_COMPUTER_SYSTEM a ,v_FullCollectionMembership b where DATEDIFF(dd,a.TimeStamp,GetDate()) > 20 and  b.CollectionID =…

  Below is the report to list computers with IP address and Subnet information from Given collection. select distinct A.Name0,c.IPAddress0 ,D.IP_Subnets0 from v_R_System A inner join v_FullCollectionMembership B on A.ResourceID=B.ResourceID Inner join v_GS_NETWORK_ADAPTER_CONFIGUR  C ON A.ResourceID=C.ResourceID Inner Join v_RA_System_IPSubnets D ON A.ResourceID=D.ResourceID where CollectionID=@COLLID and C.IPEnabled0='1' group by A.Name0,c.IPAddress0 ,D.IP_Subnets0 order by A.Name0,c.IPAddress0 ,D.IP_Subnets0 Prompt…
SCCM report to list all the advertisement that are currently assigned to computer

When you assign any advertisement (either application or Task sequence) to collection(Group of computers) ,all the advertisement will be tracked(logged) in SCCM Database with its status and other details.The advertisement will run on the computer and gives the status of it which can be find Via Default reports “All advertisement for specific computer(Report ID:126)”. What…