Find Packages ID’s SCCM

Hi guys,

I would like to introduce you very useful query in SCCM which can provide you all packages location and packages ID, content source and so on,

The main reason I would like to share it with you is because last week I had an issue with deploying Task Sequence due to some TMTXXXX ID wasn’t available which means was not distributed to my DP yet

In my case it was frustrated to look up after that I’D, I have more than 200 packages in my SCCM.
So I decided to gather all packages by a simple query in SQL and then proceed to next step.


So here it is the SQL query you may run:

select * from v_Package


Find all Packages ID in SCCM