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>>
