by Anoop C Nair
May 7, 2012 in CM2012, Configuration Manager, Reports and Queries, SCCM 2012 by Anoop C Nair
Another post for easy reference from TechNet Forum. All credits to Beamer25!!! In ConfigMgr 2012 (specifically in THIS case), “FUNCTIONS” are used rather than “VIEWS” along with datasets within SSRS. For example, to find [...]
by Rod Trent
May 3, 2012 in Reports and Queries, SCCM 2007, SCCM 2012, System Center Configuration Manager by Rod Trent
This query lists all the machines with a copy of Adobe Distiller by Version. *Requires BDNA Normalize CM Manufacturer Product Name Major Version Adobe Systems Distiller 10 Adobe Systems Distiller 9 Adobe Systems Distiller [...]
by Rod Trent
May 2, 2012 in Reports and Queries, SCCM 2007, SCCM 2012, System Center Configuration Manager by Rod Trent
This query lists all the machines with Windows Vista by Edition, and Service Pack. *Requires BDNA Normalize CM OS Manufacturer OS Name OS MajorVersion OS ServicePack OS Edition Microsoft Windows Vista Vista NULL Enterprise [...]
by Rod Trent
May 1, 2012 in Reports and Queries, SCCM 2007, SCCM 2012, System Center Configuration Manager by Rod Trent
This query lists all the machines with Windows XP by Edition, and Service Pack, *Requires BDNA Normalize CM OS Manufacturer OS Name OS MajorVersion OS ServicePack OS Edition Microsoft Windows XP XP SP2 Professional [...]
by Rod Trent
April 30, 2012 in Reports and Queries, SCCM 2007, SCCM 2012, System Center Configuration Manager by Rod Trent
This query lists all the machines with Windows 2000 by Edition, and Service Pack. *Requires BDNA Normalize CM OS Manufacturer OS Name OS MajorVersion OS ServicePack OS Edition Microsoft Windows 2000 2000 SP4 Advanced [...]
by Rod Trent
April 27, 2012 in Reports and Queries, SCCM 2007, SCCM 2012, System Center Configuration Manager by Rod Trent
This query lists all the machines with Windows 2003 R2 by Edition, and ServicePack. *Requires BDNA Normalize CM OS Manufacturer OS Name OS MajorVersion OS ServicePack OS Edition Microsoft Windows Server 2003 2003 R2 [...]
by Rod Trent
April 26, 2012 in Reports and Queries, SCCM 2007, SCCM 2012, System Center Configuration Manager by Rod Trent
This query lists all the machines with Windows 2003 by Edition, and Service Pack. *Requires BDNA Normalize CM OS Manufacturer OS Name OS MajorVersion OS ServicePack OS Edition Microsoft Windows Server 2003 2003 SP1 [...]
by Rod Trent
April 25, 2012 in Reports and Queries, SCCM 2007, SCCM 2012, System Center Configuration Manager by Rod Trent
This query lists all the machines with Windows 2008 R2 by Edition, and Service Pack. *Requires BDNA Normalize CM OS Manufacturer OS Name OS MajorVersion OS ServicePack OS Edition Microsoft Windows Server 2008 2008 [...]
by Rod Trent
April 24, 2012 in Reports and Queries, SCCM 2007, SCCM 2012, System Center Configuration Manager by Rod Trent
This query lists all the machines with Windows 2008 by Edition, and Service Pack. *Requires BDNA Normalize CM OS Manufacturer OS Name OS MajorVersion OS ServicePack OS Edition Microsoft Windows Server 2008 2008 R2 [...]
by Rod Trent
April 13, 2012 in Reports and Queries, SCCM 2007, System Center Configuration Manager by Rod Trent
This query lists all the machines with Windows 7 by Edition, and Service Pack. * Requires BDNA Normalize CM OS Manufacturer OS Name OS MajorVersion OS ServicePack OS Edition Microsoft Windows 7 7 [...]
LINK: http://aka.ms/itfsc2012
