Re: Software Inventory fails to include some products

From: Joseph Calabig [MSFT] (jcalabig_at_microsoft.com)
Date: 09/29/04 

Date: Wed, 29 Sep 2004 11:05:05 -0700

Yes. this is available in SMS 2003 and is reported by default when you turn
on Hardware Inventory.
There is even a built-in view for this: v_GS_ADD_REMOVE_PROGRAMS

You probably can start with:

select sd.Netbios_Name0, arp.ProdID0, arp.DisplayName0
from v_GS_ADD_REMOVE_PROGRAMS arp
join System_Disc sd
on arp.ResourceID = sd.ItemKey 

-- 
Thanks,
Joseph Calabig
This posting is provided "AS IS" with no warranties, and confers no rights.
"Noobie_SMS" <Noobie_SMS@discussions.microsoft.com> wrote in message 
news:00E4F3C3-6954-496E-BEB3-03D684586417@microsoft.com...
> Can I do this in SMS 2003?
>
> I need SMS report to distinguish between Standard and Professional version
> of Office, also I am not a programmer and  I can barely write script.  So 
> any
> suggestion on creating a new report and SQL statement would be greatly
> aprreciated
>
> "Joseph Calabig [MSFT]" wrote:
>
>> Software inventory is not capable of aggregating file properties to a
>> particular product.
>> It only works with file properties (file versions, company name, etc..) 
>> and
>> has no knowledge of product packaging.
>> However, you should try extending hardware inventory to capture the
>> properties reported by Add/Remove software.
>>
>> If you are well versed with SMS, you can try the steps below. If not, I
>> suggest getting your PSS engineer engaged.
>> Add this to your 2.0 mof:
>>
>> //==================================================================
>>
>> // Define registry classes for inventory reporting
>>
>> //
>>
>> // - Registry key/value class definition should be done in cimv2,
>>
>> // - SMS class definition should be done in cimv2\\sms
>>
>> //==================================================================
>>
>> //----------------------
>>
>> // Add Remove Programs
>>
>> //----------------------
>>
>>
>>
>> #pragma namespace ("\\\\.\\root\\cimv2")
>>
>>
>>
>> [ dynamic,
>>
>>   provider("RegProv"),
>>
>> 
>> ClassContext("local|HKEY_LOCAL_MACHINE\\Software\\Microsoft\\Windows\\CurrentVersion\\Uninstall")
>>
>> ]
>>
>> class Win32Reg_AddRemovePrograms
>>
>> {
>>
>>     [key]
>>
>>         string    ProdID;
>>
>>     [PropertyContext("DisplayName")]
>>
>>         string    DisplayName;
>>
>>     [PropertyContext("InstallDate")]
>>
>>         string    InstallDate;
>>
>>     [PropertyContext("Publisher")  ]
>>
>>         string    Publisher;
>>
>>     [PropertyContext("DisplayVersion")]
>>
>>         string    Version;
>>
>> };
>>
>>
>>
>> #pragma namespace (\\\\.\\root\\cimv2\\sms)
>>
>> [ SMS_Report     (TRUE),
>>
>>   SMS_Group_Name ("Add Remove Programs"),
>>
>>   SMS_Class_ID   ("MICROSOFT|ADD_REMOVE_PROGRAMS|1.0") ]
>>
>> class Win32Reg_AddRemovePrograms : SMS_Class_Template
>>
>> {
>>
>>     [SMS_Report (TRUE), key ]
>>
>>         string ProdID;
>>
>>     [SMS_Report (TRUE)      ]
>>
>>         string DisplayName;
>>
>>     [SMS_Report (TRUE)      ]
>>
>>         string InstallDate;
>>
>>     [SMS_Report (TRUE)      ]
>>
>>         string Publisher;
>>
>>     [SMS_Report (TRUE)      ]
>>
>>         string Version;
>>
>> };
>>
>> -- 
>> Thanks,
>> Joseph Calabig
>>
>>
>> This posting is provided "AS IS" with no warranties, and confers no 
>> rights.
>>
>> "Vadim Rapp" <vrapp@nospam.polyscience.com> wrote in message
>> news:O6fh2IMoEHA.628@TK2MSFTNGP10.phx.gbl...
>> > Hello,
>> >
>> > I noticed that Software Inventory fails to include some products in the
>> > list
>> > of Software Products..
>> >
>> > For instance, product "Microsoft Office 2000 SR-1 Premium" does not 
>> > appear
>> > in the list - it's just one example, there are many others. It's not
>> > per-workstation effect, but rather particular products never appear in 
>> > the
>> > list, though they are installed on many machines; while other products 
>> > on
>> > the same machines appear correctly.
>> >
>> > What might be causing this?
>> >
>> > Out SMS is v. 2.0 SP5.
>> >
>> > thanks,
>> >
>> > Vadim Rapp
>> > Polyscience, Inc.
>> >
>> >
>> >
>> >
>> >
>>
>>
>>

Relevant Pages

  • Re: Status warnings Please help.
    ... The file attempted to update inventory information in the ... > --SMS Software Inventory Processor failed to process software inventory file ... SMS Software Inventory Processor has moved ...
    (microsoft.public.sms.admin)
  • Status warnings Please help.
    ... The file attempted to update inventory information in the ... SMS site database that does not already exist, ... --SMS Software Inventory Processor failed to process software inventory file ... SMS Discovery Data Manager is not running. ...
    (microsoft.public.sms.admin)
  • Re: Query Help
    ... You can use software inventory to search for the particular file. ... or file extension on all client hard disks. ... Select to allow SMS to search subdirectories under Location. ...
    (microsoft.public.sms.admin)
  • Re: Collected File From Client is Missing Files - HELP
    ... InventoryAgent log to see if software inventory is succeeding or failing. ... When I run a report to find out how many ... Why do some files not show up to SMS? ... Next find that machin in SMS. ...
    (microsoft.public.sms.admin)
  • Re: Enable inventory of bitlocker drive status
    ... I'm interested in using SMS to monitor Bitlocker status for Vista ... the Hardware inventory cycle has gone missing again (locally on all ... notice a line regarding "Client Component item named Hardware Inventory ...
    (microsoft.public.sms.inventory)
Loading