[ConfigMgr 2007] Query to show Package Source Version

Does anyone have a query that will show me the Package Source Version of a particular Package on my DPs?

ANSWER:

Yes the following SQL Query will show you the following:

  • Package ID
  • Type
  • Site Code
  • Package Server
  • Status
  • Source Version
  • Update Time
  • Location

Here's the Query:

select * from pkgstatus where (ID = '<package_ID_you_want_to check>')

Published Friday, July 15, 2011 12:16 PM by chobbs
Filed under: , , ,

Comments

No Comments