March 10 2010

SCCM Resource Explorer

It’s often quite a painful experience to open up resource explorer in SCCM. I’ve modified a batch file (originally from to make this process very simple. Create a new batch file with the following content, it will then prompt you for all of the required parameters:

@echo off

> input1.vbs ECHO WScript.Echo InputBox( "Which SCCM client would you like to connect to?", "Resource Explorer", "Enter client name" )
FOR /F "tokens=*" %%A IN ('CSCRIPT.EXE //NoLogo input1.vbs') DO SET clientname=%%A
DEL input1.vbs

> input2.vbs ECHO WScript.Echo InputBox( "What is the SCCM server name?", "Resource Explorer", "Enter server name" )
FOR /F "tokens=*" %%A IN ('CSCRIPT.EXE //NoLogo input2.vbs') DO SET servername=%%A
DEL input2.vbs

> input3.vbs ECHO WScript.Echo InputBox( "What is the SCCM site code?", "Resource Explorer", "Enter site code" )
FOR /F "tokens=*" %%A IN ('CSCRIPT.EXE //NoLogo input3.vbs') DO SET sitecode=%%A
DEL input3.vbs

cd "Program Files (x86)Microsoft Configuration ManagerAdminUIbin"

start resourceexplorer.msc -s -sms:ResExplrQuery="SELECT ResourceID FROM SMS_R_SYSTEM WHERE NAME = '%clientname%'" -sms:connection=\%servername%rootsmssite_%sitecode%

I use a maximum of one Google Ad per post to help offset some of my blog hosting costs.


Tags: , , ,

Posted March 10, 2010 by danovich in category "SMS / SCCM

Leave a Reply