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…

Here is another report today ,to list all the computers with their maintenance window setting and are part of which collection. The maintenance window information( collection ID,Description,time etc.) is available from SQL view called v_ServiceWindow. Below is the report to display all the computer with their maintenance window settings .You can also limit this collection…

Report to list all the computer where the discovery agent time shows older than 30 days. This you can find out if you right click on the computer ,go to properties and see Agent name[0] (ex:SMS_AD_SYSTEM_DISCOVERY) respect to Agent time[0] for the above discovery method which will be the recent date. select a.Name0,b.AgentName,b.AgentTime from v_R_System…