Re: SMS SDK

Tech-Archive recommends: Fix windows errors by optimizing your registry

I have never had the need to create other views than the ones already
available.

Kim Oppalfens
"Steve Thompson" <stevethompson@xxxxxxxxxxxxx> wrote in message
news:%23mUNWwDJHHA.1912@xxxxxxxxxxxxxxxxxxxxxxx
Building on Kim's suggestion, re: predefined SMS views -- you could also
create custom views within SQL Server, then create SMS web reports to
access those views. The performance will be far better using SQL Server
views, than using WMI (think slow). And, you don't need to use the SDK,
which would be overkill for this task.

Steve
"Andrzej Jaworek" <_no_andrzejjaworek_spam_@xxxxx> wrote in message
news:em895j$b4l$2@xxxxxxxxxxxxxxxxxxxxxx
Hello,
I try to write an application that displays hardware inventory for all
clients (for example CDROMs, Mouses, Modems, Hard drivers etc). This data
would be taken of course from the SMS database. To do this I use WMI.
Using WMI queries I can get all information I need. For exmaple if want
to have all cd roms I use WMI Query:

select Main.* from SMS_R_System inner join SMS_G_System_CDROM Main on
Main.ResourceID = SMS_R_System.ResourceId

But Im not sure if it is efficient way especialy if i will have thousand
s of records.

And now my question. If I dont want to use WMI is there any other way to
do this especially using SMS SDK? It is possible to do this with Managed
SMS SiteServer Interfaces ? If yes how ? I try to find it out but with no
results.
Thank You in advance for any sugestions.

Andrzej Jaworek




.

Relevant Pages

  • Re: WMI Problem - SMS 2003 SP1 + XP SP2
    ... The installation errors relate to WMI namespaces. ... denied errors this didn't matter whether the tools were loaded locally on a ... SMS client installs and WMI starts reporting again and the various WMI tools ...
    (microsoft.public.sms.admin)
  • Re: SMS SDK
    ... predefined SMS views -- you could also ... The performance will be far better using SQL Server views, ... To do this I use WMI. ... do this especially using SMS SDK? ...
    (microsoft.public.sms.misc)
  • Re: WMI Problem - SMS 2003 SP1 + XP SP2
    ... Please open WMI control snap-in to verify the logon user on the Windows XP ... SP2 machine to SMS name spaces? ... Please verify that SMS Admins group has all logon users for the Windows XP ...
    (microsoft.public.sms.admin)
  • Re: WMI Problem - SMS 2003 SP1 + XP SP2
    ... Could you send me the WMI log files on the machine where the SMS Provider is ... The installation errors relate to WMI namespaces. ...
    (microsoft.public.sms.admin)
  • Re: WMI Problem - SMS 2003 SP1 + XP SP2
    ... Please open WMI control snap-in to verify the logon user on the Windows XP ... SP2 machine to SMS name spaces? ...
    (microsoft.public.sms.admin)