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…

Hi all ,Another report to find out the servers where IIS is installed with the version of it.this assumes that ,you have enabled the inventory agent and set the properties for .exe to not exclude windows folder.If you select exclude files from windows directory,you will not see any results in the report because inetmgr.exe will…