The Windows Management User Group
The original UK User Group
Established March 2006
Eswar Koneti's Blog
Browse by Tags
Windows Management User Group Community blogs
Get this RSS feed
Status of Packages
Tagged Content List
SCCM Report to list Computers with IP address with their Subnets from Given Collection
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...
Wed, Dec 15 2010
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...
Thu, Dec 9 2010
Report for computers which has their(Next) Maintenance Window settings in SCCM
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...
Fri, Nov 26 2010
collection Query/ Report to get computer Model/Serial Number for a given computer
Create a New report and paste the below query with prompt asking for computer name: select a.name0 ,b.SerialNumber0,c.model0 from v_R_System a,v_GS_PC_BIOS b,v_GS_COMPUTER_SYSTEM c where a.ResourceID=b.ResourceID and a.ResourceID=c.ResourceID AND a.name0=@hostname Prompt for computer name @hostname...
Wed, Nov 10 2010