I've never found a report for it, but I had written something a long while
back for 2007. I just tested it and it works for 2012 package/program
deployments, too. It looks like that's what you're looking for.
#setting the variables for the connection string.
$script:strCentralSiteServer = "ABCServer123"
$script:strCentralSiteCode = "ABC"
$AdvertisementID = 'ABC20092'
#Gathering the Advertisement into an object
$Advert = Get-WmiObject -computername $script:StrCentralSiteServer
-namespace root\sms\site_$script:strCentralSiteCode -class sms_advertisement
| Where-Object {$_.advertisementID -eq "$($AdvertisementID)"}
$AdvertPath =
"\\$script:strCentralSiteServer\root\sms\site_"+$script:strCentralSiteCode+"
:SMS_Advertisement.AdvertisementID='$($advert.advertisementid)'"
$AdvertSchedule = [WMI]$AdvertPath
foreach ($schedule in $AdvertSchedule.AssignedSchedule)
{
#Gathering and formatting the data about the advertisement schedules.
$AdvertScheduleStartTime = $schedule | select StartTime
$AdSched =
$AdvertSchedule.ConvertToDateTime($AdvertScheduleStartTime.StartTime)
write-host $AdSched
}
From: [email protected] [mailto:[email protected]]
On Behalf Of Damien Solodow
Sent: Tuesday, October 13, 2015 2:49 PM
To: [email protected]
Subject: RE: [mssms] Query assistance
Might check here:
https://gallery.technet.microsoft.com/scriptcenter/Find-the-Status-of-an-SCC
M-e86cc346
There may also be a report that provides the necessary info.
DAMIEN SOLODOW
Senior Systems Engineer
317.447.6033 (office)
317.447.6014 (fax)
HARRISON COLLEGE
From: [email protected] [mailto:[email protected]]
On Behalf Of HELMS, DAVID C
Sent: Tuesday, October 13, 2015 2:38 PM
To: [email protected]
Subject: [mssms] Query assistance
I'm trying to write a query where I can list all the mandatory times for my
software deployments but unable to find this information in the database.
I can find the scheduled and expiration time, but not the mandatory. It
would be convenient to be able to populate this information rather than
having to open each deployment to check.
Anyone know which view would contain this or have a script to share that has
this info?
