SCCM-TOOLS.COM - Right Click - Advertisement Status Report

Advertisement Status Report

Right click on an advertisment and run the Status of Advtertisment Report.

Code

--------- reports.vbs ------------

'' report.vbs <server>  <ReportID>  <Parameter Value>
'' Report.vbs sms-serve1 170 MachineName ##Sub:name##
URL = "http://#0#/SMSReporting_SYS/Report.asp?ReportID=#1#"
URL2= "http://#0#/SMSReporting_SYS/Reports.asp?ReportID=#1#"
Set objArgs = WScript.Arguments  ' pull from external parameters
getnext=-3
for Each item in objArgs

if getnext=-3  then
       URL=Replace(URL,"#0#", item)
       URL2=Replace(URL2,"#0#", item)
     end if

if getnext=-2 then
       URL=Replace(URL,"#1#", item)
       URL2=Replace(URL2,"#1#", item)
       getnext=-1
     end if

if getnext=0 then
        URL = URL + "&" + item +"="
    End if

if getnext=1 then
        URL = URL + item
        getnext=-1
    End if
   getnext=getnext+1

Set Shell = CreateObject("Wscript.Shell")
'check to see if any parameters were passed

if InStr(URL,"&")>0 then   'if pass a parameter then use it
    shell.Run(URL)
    wscript.echo url
  else    'else run the report request page
    shell.Run(URL2)

end if

-------------------------------------------------------------

---------------Reports.xml for 66c75b33-4ca4-4f00-ae7f-3bcf31ee5bdc --------------------

<ActionDescription Class="Executable" DisplayName="Advertisements Status Report" MnemonicDisplayName="AdvReport"  Description="Status of a specific advertisment">
        <Executable>
          <FilePath>C:\Program Files\MCNS\reports\reports.vbs</FilePath>
            <Parameters>ReportingpointServerName 107 AdvertID ##SUB:AdvertisementID##</Parameters>
        </Executable>
      </ActionDescription>

</ActionGroups>

</ActionDescription>

-----------------------------------------------------------------------------

Documentation

You will need create the necessary folders

The folders under actions contains the GUIDs and xml files necessary to run reports per a single
computer 66c75b33-4ca4-4f00-ae7f-3bcf31ee5bdc.
Move the files and modify as necessary.

For the file that will launch the report, reports.vbs,  you will need to move it from the
 "Sccm tools" folder to where ever you have your files.

The program can run any of the reports if you pass the correct parameters

report.vbs <server>  <ReportID>  <Parameter & Value> <Parameter  & Value>  <Parameter & Value>
Report.vbs sms-serve1 107 AdvertID ##SUB:AdvertisementID##

Note that I have modifed the paramters for a updates report.  I found that if I remove the updateID and product that it would show
all the updates for a specific machine so it doesn't represent the report
100%.

##SUB:NetBIOSName## Computer Name
##SUB:ResourceID## Resource ID number
##SUB:Name## Computer Name
##SUB:CollectionID## Collection ID
##SUB:ADVERTISEMENTID## Advertisment ID

Created by
Matthew Hudson