Full Details : http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/188bb324-9217-4fa6-b814-06a3d353bf52 Boundary information (AD Site) added . select distinct v_GS_SYSTEM.Name0 as 'Computer Name',A.AD_Site_Name0, substring(AccountName0,charindex('Domain=',Accountname0)+8,(charindex('Name=',Accountname0)-charindex('Domain=',Accountname0)-10)) as 'Domain Name', substring(AccountName0,len(AccountName0)-charindex('"',reverse(AccountName0),2)+2,charindex('"',reverse(AccountName0),2)-2) as 'User Name' from v_GS_SYSTEM INNER JOIN v_GS_LocalAdmins ON v_GS_SYSTEM.ResourceID = v_GS_LocalAdmins.ResourceID INNER JOIN v_R_System A ON v_GS_SYSTEM.ResourceID=A.ResourceID JOIN v_FullCollectionMembership FCM on v_gs_system.ResourceID = FCM.ResourceID where (AccountName0 not like '%Administrator%' AND AccountName0 not like…

Did you ever find difficulty in identifying the site system information when you have multi-tier hierarchy like  central,multiple primary sites and each primary has primary and secondary sites. It is difficult to identify and check for site settings (like discovery,Site maintenance Tasks etc.) OR Site Component Information until you know all site verywell . To…
sccm 2012 client log files

From SCCM 2007 to SCCM 2012,lot many features and the way console design is completely different. With the features change, lot many log files changed/ New from sccm 2007. SCCM 2012 client log files location has been changed from system32/SYSWOW64 to windows (%windir%) directory. The following log files can be found from SCCM 2012 log…

SCCM 2012 SDK provides information applicable to administrators who want to automate Configuration Manager through script and to developers adding features and extensions to base Configuration Manager functionality. Configuration Manager SDK contains documentation and samples that are useful in developing applications that access and modify Configuration Manager data. It also provides comprehensive reference material for…

time to time while working with SCCM application virtualization, i come across several issues in troubleshooting why the virtual apps doesn't load correctly /why they don't go way when you say not applicable/not needed for someone using very powerful command WMIC. Here are some of the WMIC commands : What is WMIC : WMIC is…

Listing down Technical videos on SCCM 2012 (system center 2012 Configuration Manager) and other technical stuff for quick reference . Thanks to Johan(Deploymentartist). ConfigMgr 2012 Software Distribution Part 1 - With Wally Mead Run in Full Screen and HD (720). Courtesy of Deployment Artist and Knowledge Factory - Breakout sessions presented by Wally Mead during…

The standard way to remove Advertised app-v applications from client machines is to set expiration of the advertisement /deletion with setting “remove this package from client when no longer advertised” and it should work though it takes a while but this procedure doesn’t work. Recently had an issue with App-v Applications(machines having both msi and…

was looking at machine to see what advertisements /packages are targeted to sccm client though you can get this information directly from SCCM reports if you have access else wrote a simple script which gives you what packages with program name,Command line used ,ADV ID,Package ID information. ON ERROR RESUME NEXT Set fso=CreateObject("scripting.filesystemobject") 'create text…