Below is the report to list computers with IP address and Subnet information from Given collection. select distinct A.Name0,c.IPAddress0…
Browsing: SQL
When you assign any advertisement (either application or Task sequence) to collection(Group of computers) ,all the advertisement will be tracked(logged)…
Here is another report today ,to list all the computers with their maintenance window setting and are part of which…
Report to list all the computer where the discovery agent time shows older than 30 days. This you can find…
Today,I come across several advertisement status message IDs for a particular advertisement which can be viewed under system status--->advertisement status.…
There might be some scenarios where in you would like to fetch computers with IE Versions, how many of them…
Long back created a report for the monthly Patch statistics which can be found in http://www.windows-noob.com/forums/index.php?/topic/1764-patch-management-report-in-sms-2003/#entry6281 Below all the reports…
You might get a request to find out all the computers in organisation connected to which printers.There might be differetn…