Hello guys,

Using PowerShell (or GUI) I want to retrieve the application installed by a specific user using the Application Catalog.
I'm able to retrieve the application requests that need an approval via something like:

Get-WMIObject -computerName <SCCM_SERVER> -NameSpace 'root\SMS\Site_<SiteCode>' -class SMS_UserApplicationRequest

But what about the apps that do NOT need an approval ? Where can i find this information ?

Any help would be appreciated Thanks!

$AssignmentIDs = (Get-WMIObject -ComputerName <SCCM_SERVER> -Namespace root\sms\Site_<SiteCode> -Query "SELECT * FROM SMS_Advertisement WHERE OfferType=2").AssignmentID
foreach ($AssignmentID in $AssignmentIDs) {
  Get-WmiObject -ComputerName <SCCM_SERVER> -Namespace root\sms\site_<SiteCode> -Query "SELECT * FROM SMS_AppDeploymentAssetDetails WHERE AssignmentID = $AssignmentID and UserName = <YourUserName>"
}

This code is provided "as is".

• Edited by Gaëtan Hermann 11 hours 29 minutes ago
• Proposed as answer by Gaëtan Hermann 11 hours 29 minutes ago
• Unproposed as answer by François-Xavier CatMVP 8 hours 6 minutes ago

$AssignmentIDs = (Get-WMIObject -ComputerName <SCCM_SERVER> -Namespace root\sms\Site_<SiteCode> -Query "SELECT * FROM SMS_Advertisement WHERE OfferType=2").AssignmentID
foreach ($AssignmentID in $AssignmentIDs) {
  Get-WmiObject -ComputerName <SCCM_SERVER> -Namespace root\sms\site_<SiteCode> -Query "SELECT * FROM SMS_AppDeploymentAssetDetails WHERE AssignmentID = $AssignmentID and UserName = <YourUserName>"
}

This code is provided "as is".

• Edited by Gaëtan Hermann Friday, September 04, 2015 8:24 PM
• Proposed as answer by Gaëtan Hermann Friday, September 04, 2015 8:25 PM
• Unproposed as answer by François-Xavier CatMVP Friday, September 04, 2015 11:47 PM