You won’t be able to do this in SQL.
Requirements are part of the deployment type and this is stored in XML. Try
this snippet to get started with deserialzing XML from SQL
gwmi -ComputerName $server -Namespace root\sms\site_$code -class
sms_application | ?{$_.IsLatest -eq $true} | %{
#get the instance of the application
$app = [wmi]$_.__PATH
#deserialize the XML data
$appXML =
[Microsoft.ConfigurationManagement.ApplicationManagement.Serialization.SccmSerializer]::DeserializeFromString($app.SDMPackageXML,$true)
}
You can then use the $appXML variable to access nodes of the XML.
My blog
here<https://andrewdcraig.wordpress.com/2013/01/31/configmgr-2012-change-application-source-path/>
shows how to change the source path of application, as an example.
Andrew Craig | workplace solutions
itnetX AG | bremgartenstrasse 37, 3012 bern, switzerland | industriestrasse 46,
8152 glattbrugg, switzerland
cloud & datacenter solutions | management solutions | workplace solutions |
software solutions | managed services
http://www.itnetx.ch<http://www.itnetx.ch/> | (b) +41 848 99 0000 | (m) +41 791
01 6976 | [email protected]<mailto:[email protected]>
[MMS2015Badges_LEARNCENTER]
From: [email protected] [mailto:[email protected]] On
Behalf Of Boseman, Marcia H - Raleigh, NC
Sent: 07 April 2016 17:47
To: [email protected]
Subject: [mssms] SCCM 2012 SQL Query Assistance
I am trying to put together a script which will allow me to see all the
requirements that are listed for all Applications I have deployed in SCCM 2012.
Does anyone have any ideas or suggestions?
