Nevermind, found the value. Select OS.PackageID, prog.ProgramName,Name,Platform,MinVersion,Maxversion from dbo.V_OS_Details as OS join v_Program as prog on Prog.PackageID = OS.PackageID
This will give you all of the programs/packages and the associated versions. You may need to tweak this a small amount to run as an SCCM report instead of a SQL report. On Tue, Oct 29, 2013 at 4:27 PM, Stephen Owen <[email protected]> wrote: > Question : did you actually use the OS Supported, Time and Space consumed > fields in your packages? I've seen many places leave those fields empty > (i.e. you may not have the information available) > > I've taken a look and as far as I can tell, the information is stored in > dbo.V_Program, likely under the ProgramFlags column. > > However, the OS for each is undocumented, based on this blog post ( > http://myitforum.com/cs2/blogs/jnelson/archive/2011/06/21/158110.aspx). > > If someone wanted to be very awesome, they could check each box on the > program requirements and see how this affects the flag, and > reverse-engineer the values. > > > > > On Tue, Oct 29, 2013 at 3:44 PM, Ranvir singh <[email protected]>wrote: > >> SCCM 2007 R3.. SQL 2008 >> >> >> On Wed, Oct 30, 2013 at 1:10 AM, <[email protected]>wrote: >> >>> What version of ConfigMgr do you have?**** >>> >>> ** ** >>> >>> *Christopher Catlett* >>> >>> Consultant | Detroit**** >>> >>> *[image: MCTS_2013_small]* >>> >>> * * >>> >>> *Sogeti USA* >>> >>> Office 248-876-9738 |Fax 877.406.9647 **** >>> >>> 26957 Northwestern Highway, Suite 130, Southfield, MI 48033-8456**** >>> >>> www.us.sogeti.com**** >>> >>> ** ** >>> >>> *From:* [email protected] [mailto: >>> [email protected]] *On Behalf Of *Ranvir singh >>> *Sent:* Tuesday, October 29, 2013 3:26 PM >>> >>> *To:* [email protected] >>> *Subject:* Re: [mssms] SQL Query For all Packages supported platform >>> enabled**** >>> >>> ** ** >>> >>> Yes **** >>> >>> ** ** >>> >>> On Wed, Oct 30, 2013 at 12:53 AM, <[email protected]> >>> wrote:**** >>> >>> To clarify:**** >>> >>> You want a list of all packages, with the platforms they support?**** >>> >>> **** >>> >>> *Christopher Catlett***** >>> >>> Consultant | Detroit**** >>> >>> *[image: MCTS_2013_small]***** >>> >>> * ***** >>> >>> *Sogeti USA***** >>> >>> Office 248-876-9738 |Fax 877.406.9647 **** >>> >>> 26957 Northwestern Highway, Suite 130, Southfield, MI 48033-8456**** >>> >>> www.us.sogeti.com**** >>> >>> **** >>> >>> *From:* [email protected] [mailto: >>> [email protected]] *On Behalf Of *Ranvir singh >>> *Sent:* Tuesday, October 29, 2013 3:13 PM >>> *To:* [email protected] >>> *Subject:* Re: [mssms] SQL Query For all Packages supported platform >>> enabled**** >>> >>> **** >>> >>> For Singe site or Overall ( All sites's..I'm Ok to execute in site by >>> site) preferred is from All sites**** >>> >>> **** >>> >>> And Supporting Platform, Like 1 Package ( Office 2013) supporting OS >>> Windows XP or Windows Server 2008 , Windows 7 ( includes X86, X64)...*** >>> * >>> >>> **** >>> >>> Any help!!!**** >>> >>> **** >>> >>> **** >>> >>> **** >>> >>> On Wed, Oct 30, 2013 at 12:19 AM, <[email protected]> >>> wrote:**** >>> >>> You want a list of all packages, from a single site (that also support >>> a specific platform)?**** >>> >>> **** >>> >>> *Christopher Catlett***** >>> >>> Consultant | Detroit**** >>> >>> *[image: MCTS_2013_small]***** >>> >>> * ***** >>> >>> *Sogeti USA***** >>> >>> Office 248-876-9738 |Fax 877.406.9647 **** >>> >>> 26957 Northwestern Highway, Suite 130, Southfield, MI 48033-8456**** >>> >>> www.us.sogeti.com**** >>> >>> **** >>> >>> *From:* [email protected] [mailto: >>> [email protected]] *On Behalf Of *Ranvir singh >>> *Sent:* Tuesday, October 29, 2013 1:14 PM >>> *To:* [email protected] >>> *Subject:* [mssms] SQL Query For all Packages supported platform enabled >>> **** >>> >>> **** >>> >>> Hi All,**** >>> >>> **** >>> >>> Im just searching for all Packages in site with supporting platform >>> enabled Operating system**** >>> >>> **** >>> >>> ANy help Please**** >>> >>> **** >>> >>> **** >>> >>> **** >>> >>> **** >>> >>> ** ** >>> >>> ** ** >>> >>> ** ** >>> >>> >> >> > >
<<image001.jpg>>
