Tuesday, September 12, 2017

SQL query - List of all Applications referenced in Task Sequences

Since I was unable to find this query online, I decided to make it myself.  This SQL query lists all referenced applications in all Task Sequences in SCCM.

select app.DisplayName [Application],TS.Name [TS Name],TS.Description [TSDescription] From dbo.fn_ListLatestApplicationCIs(1033) app
inner join v_TaskSequenceAppReferencesInfo TSApp on app.ModelName=TSApp.RefAppModelName
inner join v_TaskSequencePackage TS on TS.PackageID=TSApp.PackageID
order by [Application]

This can be useful when cleaning up old applications and you want a quick way to show what Task Sequences are using what applications.

1 comment:

  1. Casinos Near Washington State - MapYRO
    Find 전주 출장마사지 Casinos Near Washington State 진주 출장마사지 with MapYRO. Find Casinos Near Washington State with 경상북도 출장마사지 MapYRO. Find Casinos Near Washington State with 군산 출장샵 MapYRO. 고양 출장안마

    ReplyDelete