Configuration Manager Inventory Forum

Information from registry

Tue, 24 Nov 2009 15:55:22 Z

I need to pull some information from our Virtual host servers using SCCM. Information I require is under:
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Virtualization]
and I will require MinimumMacAddress as well as MaximumMacAddress.

I understand that I need to modify sms_def.mof file? Can anyone help me?

Problem with _hist tables, when creating new classes in sms_def.mof (SMS 2003).

Wed, 25 Nov 2009 06:28:30 Z

Hi all!
Sorry for my English :)

environment:
Sms 2003 sp3 (version 2.50.4253.3000)

situation:

1. Add to sms_def.mof new class. Anyone, for example:

#pragma namespace("\\\\.\\ROOT\\CIMV2")
#pragma deleteclass("Win32_volume",NOFAIL)

#pragma namespace("\\\\.\\ROOT\\CIMV2\\SMS")
#pragma deleteclass("Win32_volume",NOFAIL)




[ SMS_Report     (TRUE),



  SMS_Group_Name ("Volume"),



  SMS_Class_ID   ("MICROSOFT|Volume|1.0")]







class WIN32_Volume : SMS_Class_Template



{



    [SMS_Report (TRUE)      ]  



        uint64     Capacity;



    [SMS_Report (TRUE)      ]  



        string     Caption;



    [SMS_Report (TRUE)      ]  



        boolean    Compressed;



    [SMS_Report (TRUE)      ]  



        string     Description;



    [SMS_Report (TRUE),KEY  ]  



        string     DeviceID;



    [SMS_Report (TRUE)      ]  



        string     DriveLetter;



    [SMS_Report (TRUE)      ]  



        uint32     DriveType;



    [SMS_Report (TRUE)      ]  



        string     FileSystem;



    [SMS_Report (TRUE)      ]  



        uint64     FreeSpace;



    [SMS_Report (TRUE)      ]  



        boolean    IndexingEnabled;



    [SMS_Report (TRUE)      ]  



        string     Label;



    [SMS_Report (TRUE)      ]  



        string     Name;



    [SMS_Report (TRUE)      ]  



        string     PNPDeviceID;



    [SMS_Report (TRUE)      ]  



        string     SystemName;



};

2) Push hardware Inventory on clients

3) new tables in sms database
Volume_DATA
Volume_HIST

4) But
When PC got >1 Volumes
a. first inventored volume inserts in Volume_DATA
b. second inventored volume inserts in Volume_DATA
c. first inventored volume inserts in Volume_HIST
d. first inventored volume deletes from Volume_DATA
...

for example, I have now:

http://s52.radikal.ru/i135/0911/50/711470deb9e8.jpg

It seems like SMS don`t see "KEY" in new class.

it happens when I add any other class, where one pc have values >1

autocreated procedures in sql db for "Volume example":

pVolume_DATA














CREATE PROCEDURE dbo.pVolume_DATA @Pragma int ,@MachineID int ,@TimeKey datetime ,@AgentID int ,@Capacity00 int  =NULL,@Caption00 varchar(255)  =NULL,@DeviceID00 varchar(255)  =NULL,@DriveLetter00 varchar(255)  =NULL,@DriveType00 varchar(255)  =NULL,@FreeSpace00 int  =NULL,@Label00 varchar(255)  =NULL,@Name00 varchar(255)  =NULL,@QuotasEnabled00 int  =NULL,@SystemName00 varchar(255)  =NULL AS 



 BEGIN 



    declare @RevisionID int, @InstanceKey int, @ExTimeKey datetime, @Deleted int 



   select @Deleted = 0 



   select @InstanceKey = InstanceKey, @RevisionID = RevisionID, @ExTimeKey = TimeKey 



   from Volume_DATA 



   where MachineID = @MachineID 



 IF (isnull(@InstanceKey,0) != 0) 



  BEGIN 



   IF EXISTS 



    ( 



     select MachineID from Volume_DATA



    where InstanceKey = @InstanceKey and MachineID = @MachineID  and Capacity00 = @Capacity00 and Caption00 = @Caption00 and DeviceID00 = @DeviceID00 and DriveLetter00 = @DriveLetter00 and DriveType00 = @DriveType00 and FreeSpace00 = @FreeSpace00 and Label00 = @Label00 and Name00 = @Name00 and QuotasEnabled00 = @QuotasEnabled00 and SystemName00 = @SystemName00



    ) 



      return 



 ELSE 



   IF (@ExTimeKey > @TimeKey) 



      return 



  END 



 IF (isnull(@InstanceKey,0) = 0 ) 



 BEGIN 



    select @InstanceKey = InstanceKey  from Volume_HIST



 where MachineID = @MachineID 



 IF (isnull(@InstanceKey, 0) != 0) 



 BEGIN 



   select @Deleted = 1 



    select @RevisionID = max(RevisionID) from Volume_HIST where MachineID = @MachineID and InstanceKey = @InstanceKey 



 END 



 END 







 IF (isnull(@InstanceKey,0) != 0 and @Deleted = 0) 



   BEGIN 



     insert into Volume_HIST(MachineID, InstanceKey, RevisionID, TimeKey, AgentID, Capacity00, Caption00, DeviceID00, DriveLetter00, DriveType00, FreeSpace00, Label00, Name00, QuotasEnabled00, SystemName00)



     select MachineID, InstanceKey, RevisionID, TimeKey, AgentID , Capacity00, Caption00, DeviceID00, DriveLetter00, DriveType00, FreeSpace00, Label00, Name00, QuotasEnabled00, SystemName00



 from Volume_DATA where MachineID = @MachineID and InstanceKey = @InstanceKey 



     select @RevisionID = RevisionID from Volume_DATA     where MachineID = @MachineID and InstanceKey = @InstanceKey 



   END  



 IF (@RevisionID IS NULL) 



    select @RevisionID = 0 



 select @RevisionID = @RevisionID + 1 



 IF (isnull(@InstanceKey,0) = 0) 



   BEGIN 



      exec @InstanceKey = sp_GetNextInstanceKey_Internal 5, 'MICROSOFT|VOLUME|1.0' 



   END 



IF EXISTS (select MachineID from Volume_DATA where MachineID = @MachineID and InstanceKey = @InstanceKey) 



 BEGIN 



     UPDATE Volume_DATA



     set  RevisionID = @RevisionID,  AgentID = @AgentID,  TimeKey = @TimeKey , Capacity00 = @Capacity00, Caption00 = @Caption00, DeviceID00 = @DeviceID00, DriveLetter00 = @DriveLetter00, DriveType00 = @DriveType00, FreeSpace00 = @FreeSpace00, Label00 = @Label00, Name00 = @Name00, QuotasEnabled00 = @QuotasEnabled00, SystemName00 = @SystemName00



     WHERE MachineID = @MachineID and InstanceKey = @InstanceKey 



   END 



 ELSE 



   BEGIN 



     IF (@Pragma = 1) 



        BEGIN 



          select 2 



          return 



        END 



     ELSE  



         INSERT into Volume_DATA (MachineID, InstanceKey, RevisionID, TimeKey, AgentID, Capacity00, Caption00, DeviceID00, DriveLetter00, DriveType00, FreeSpace00, Label00, Name00, QuotasEnabled00, SystemName00) 



         values  (@MachineID, @InstanceKey, @RevisionID, @TimeKey, @AgentID , @Capacity00, @Caption00, @DeviceID00, @DriveLetter00, @DriveType00, @FreeSpace00, @Label00, @Name00, @QuotasEnabled00, @SystemName00) 



   END 



END 







GO

dVolume_DATA







CREATE PROCEDURE dbo.dVolume_DATA @Pragma int ,@MachineID int ,@TimeKey datetime ,@AgentID int ,@Capacity00 int  =NULL,@Caption00 varchar(255)  =NULL,@DeviceID00 varchar(255)  =NULL,@DriveLetter00 varchar(255)  =NULL,@DriveType00 varchar(255)  =NULL,@FreeSpace00 int  =NULL,@Label00 varchar(255)  =NULL,@Name00 varchar(255)  =NULL,@QuotasEnabled00 int  =NULL,@SystemName00 varchar(255)  =NULL AS 



 BEGIN 



  declare @RevisionID int, @InstanceKey int 



 select @InstanceKey = InstanceKey, @RevisionID = RevisionID  from Volume_DATA



 where MachineID = @MachineID 



   BEGIN



  IF (isnull(@InstanceKey,0) != 0) 



 BEGIN 



   insert into Volume_HIST(MachineID, InstanceKey, RevisionID, TimeKey, AgentID, Capacity00, Caption00, DeviceID00, DriveLetter00, DriveType00, FreeSpace00, Label00, Name00, QuotasEnabled00, SystemName00)



     select MachineID, InstanceKey, RevisionID, TimeKey, AgentID , Capacity00, Caption00, DeviceID00, DriveLetter00, DriveType00, FreeSpace00, Label00, Name00, QuotasEnabled00, SystemName00



 from Volume_DATA where MachineID = @MachineID and InstanceKey = @InstanceKey 



 select @RevisionID = max(RevisionID) + 1 from Volume_HIST



 where MachineID = @MachineID and InstanceKey = @InstanceKey IF (@RevisionID = NULL) 



 select @RevisionID = 1 



 insert into Volume_HIST (MachineID, InstanceKey, TimeKey, RevisionID) 



 select @MachineID, @InstanceKey, @TimeKey, @RevisionID 



   delete from Volume_DATA where MachineID = @MachineID and InstanceKey = @InstanceKey 



   END 



 return 



  END 



 END 







GO

for example "Disk procedures" where deviceid is a key parameter too in sms_def.mof

PDisk

CREATE PROCEDURE dbo.pDisk_DATA @Pragma int ,@MachineID int ,@TimeKey datetime ,@AgentID int ,@Availability0 int  =NULL,@Caption00 varchar(255)  =NULL,@Description0 varchar(255)  =NULL,@DeviceID0 varchar(255)  =NULL,@Index0 int  =NULL,@InterfaceType0 varchar(255)  =NULL,@Manufacturer00 varchar(255)  =NULL,@MediaType0 varchar(255)  =NULL,@Model00 varchar(255)  =NULL,@Name0 varchar(255)  =NULL,@PNPDeviceID00 varchar(255)  =NULL,@Partitions0 int  =NULL,@SCSIBus0 int  =NULL,@SCSILogicalUnit0 int  =NULL,@SCSIPort0 int  =NULL,@SCSITargetId0 int  =NULL,@Size0 int  =NULL,@Status00 varchar(255)  =NULL,@SystemName0 varchar(255)  =NULL,@TotalCylinders00 varchar(255)  =NULL,@TotalSectors00 varchar(255)  =NULL,@TotalTracks00 varchar(255)  =NULL AS 
 BEGIN 
    declare @RevisionID int, @InstanceKey int, @ExTimeKey datetime, @Deleted int 
   select @Deleted = 0 
   select @InstanceKey = InstanceKey, @RevisionID = RevisionID, @ExTimeKey = TimeKey 
   from Disk_DATA 
   where MachineID = @MachineID  and DeviceID0 = @DeviceID0
 IF (isnull(@InstanceKey,0) != 0) 
  BEGIN 
   IF EXISTS 
    ( 
     select MachineID from Disk_DATA
    where InstanceKey = @InstanceKey and MachineID = @MachineID  and Availability0 = @Availability0 and Caption00 = @Caption00 and Description0 = @Description0 and DeviceID0 = @DeviceID0 and Index0 = @Index0 and InterfaceType0 = @InterfaceType0 and Manufacturer00 = @Manufacturer00 and MediaType0 = @MediaType0 and Model00 = @Model00 and Name0 = @Name0 and PNPDeviceID00 = @PNPDeviceID00 and Partitions0 = @Partitions0 and SCSIBus0 = @SCSIBus0 and SCSILogicalUnit0 = @SCSILogicalUnit0 and SCSIPort0 = @SCSIPort0 and SCSITargetId0 = @SCSITargetId0 and Size0 = @Size0 and Status00 = @Status00 and SystemName0 = @SystemName0 and TotalCylinders00 = @TotalCylinders00 and TotalSectors00 = @TotalSectors00 and TotalTracks00 = @TotalTracks00
    ) 
      return 
 ELSE 
   IF (@ExTimeKey > @TimeKey) 
      return 
  END 
 IF (isnull(@InstanceKey,0) = 0 ) 
 BEGIN 
    select @InstanceKey = InstanceKey  from Disk_HIST
 where MachineID = @MachineID  and DeviceID0 = @DeviceID0
 IF (isnull(@InstanceKey, 0) != 0) 
 BEGIN 
   select @Deleted = 1 
    select @RevisionID = max(RevisionID) from Disk_HIST where MachineID = @MachineID and InstanceKey = @InstanceKey 
 END 
 END

 IF (isnull(@InstanceKey,0) != 0 and @Deleted = 0) 
   BEGIN 
     insert into Disk_HIST(MachineID, InstanceKey, RevisionID, TimeKey, AgentID, Availability0, Caption00, Description0, DeviceID0, Index0, InterfaceType0, Manufacturer00, MediaType0, Model00, Name0, PNPDeviceID00, Partitions0, SCSIBus0, SCSILogicalUnit0, SCSIPort0, SCSITargetId0, Size0, Status00, SystemName0, TotalCylinders00, TotalSectors00, TotalTracks00)
     select MachineID, InstanceKey, RevisionID, TimeKey, AgentID , Availability0, Caption00, Description0, DeviceID0, Index0, InterfaceType0, Manufacturer00, MediaType0, Model00, Name0, PNPDeviceID00, Partitions0, SCSIBus0, SCSILogicalUnit0, SCSIPort0, SCSITargetId0, Size0, Status00, SystemName0, TotalCylinders00, TotalSectors00, TotalTracks00
 from Disk_DATA where MachineID = @MachineID and InstanceKey = @InstanceKey 
     select @RevisionID = RevisionID from Disk_DATA     where MachineID = @MachineID and InstanceKey = @InstanceKey 
   END  
 IF (@RevisionID IS NULL) 
    select @RevisionID = 0 
 select @RevisionID = @RevisionID + 1 
 IF (isnull(@InstanceKey,0) = 0) 
   BEGIN 
      exec @InstanceKey = sp_GetNextInstanceKey_Internal 5, 'MICROSOFT|DISK|1.0' 
   END 
IF EXISTS (select MachineID from Disk_DATA where MachineID = @MachineID and InstanceKey = @InstanceKey) 
 BEGIN 
     UPDATE Disk_DATA
     set  RevisionID = @RevisionID,  AgentID = @AgentID,  TimeKey = @TimeKey , Availability0 = @Availability0, Caption00 = @Caption00, Description0 = @Description0, DeviceID0 = @DeviceID0, Index0 = @Index0, InterfaceType0 = @InterfaceType0, Manufacturer00 = @Manufacturer00, MediaType0 = @MediaType0, Model00 = @Model00, Name0 = @Name0, PNPDeviceID00 = @PNPDeviceID00, Partitions0 = @Partitions0, SCSIBus0 = @SCSIBus0, SCSILogicalUnit0 = @SCSILogicalUnit0, SCSIPort0 = @SCSIPort0, SCSITargetId0 = @SCSITargetId0, Size0 = @Size0, Status00 = @Status00, SystemName0 = @SystemName0, TotalCylinders00 = @TotalCylinders00, TotalSectors00 = @TotalSectors00, TotalTracks00 = @TotalTracks00
     WHERE MachineID = @MachineID and InstanceKey = @InstanceKey 
   END 
 ELSE 
   BEGIN 
     IF (@Pragma = 1) 
        BEGIN 
          select 2 
          return 
        END 
     ELSE  
         INSERT into Disk_DATA (MachineID, InstanceKey, RevisionID, TimeKey, AgentID, Availability0, Caption00, Description0, DeviceID0, Index0, InterfaceType0, Manufacturer00, MediaType0, Model00, Name0, PNPDeviceID00, Partitions0, SCSIBus0, SCSILogicalUnit0, SCSIPort0, SCSITargetId0, Size0, Status00, SystemName0, TotalCylinders00, TotalSectors00, TotalTracks00) 
         values  (@MachineID, @InstanceKey, @RevisionID, @TimeKey, @AgentID , @Availability0, @Caption00, @Description0, @DeviceID0, @Index0, @InterfaceType0, @Manufacturer00, @MediaType0, @Model00, @Name0, @PNPDeviceID00, @Partitions0, @SCSIBus0, @SCSILogicalUnit0, @SCSIPort0, @SCSITargetId0, @Size0, @Status00, @SystemName0, @TotalCylinders00, @TotalSectors00, @TotalTracks00) 
   END 
END 
GO







DDISK


CREATE PROCEDURE dbo.dDisk_DATA @Pragma int ,@MachineID int ,@TimeKey datetime ,@AgentID int ,@Availability0 int  =NULL,@Caption00 varchar(255)  =NULL,@Description0 varchar(255)  =NULL,@DeviceID0 varchar(255)  =NULL,@Index0 int  =NULL,@InterfaceType0 varchar(255)  =NULL,@Manufacturer00 varchar(255)  =NULL,@MediaType0 varchar(255)  =NULL,@Model00 varchar(255)  =NULL,@Name0 varchar(255)  =NULL,@PNPDeviceID00 varchar(255)  =NULL,@Partitions0 int  =NULL,@SCSIBus0 int  =NULL,@SCSILogicalUnit0 int  =NULL,@SCSIPort0 int  =NULL,@SCSITargetId0 int  =NULL,@Size0 int  =NULL,@Status00 varchar(255)  =NULL,@SystemName0 varchar(255)  =NULL,@TotalCylinders00 varchar(255)  =NULL,@TotalSectors00 varchar(255)  =NULL,@TotalTracks00 varchar(255)  =NULL AS 
 BEGIN 
  declare @RevisionID int, @InstanceKey int 
 select @InstanceKey = InstanceKey, @RevisionID = RevisionID  from Disk_DATA
 where MachineID = @MachineID  and DeviceID0 = @DeviceID0
   BEGIN
  IF (isnull(@InstanceKey,0) != 0) 
 BEGIN 
   insert into Disk_HIST(MachineID, InstanceKey, RevisionID, TimeKey, AgentID, Availability0, Caption00, Description0, DeviceID0, Index0, InterfaceType0, Manufacturer00, MediaType0, Model00, Name0, PNPDeviceID00, Partitions0, SCSIBus0, SCSILogicalUnit0, SCSIPort0, SCSITargetId0, Size0, Status00, SystemName0, TotalCylinders00, TotalSectors00, TotalTracks00)
     select MachineID, InstanceKey, RevisionID, TimeKey, AgentID , Availability0, Caption00, Description0, DeviceID0, Index0, InterfaceType0, Manufacturer00, MediaType0, Model00, Name0, PNPDeviceID00, Partitions0, SCSIBus0, SCSILogicalUnit0, SCSIPort0, SCSITargetId0, Size0, Status00, SystemName0, TotalCylinders00, TotalSectors00, TotalTracks00
 from Disk_DATA where MachineID = @MachineID and InstanceKey = @InstanceKey 
 select @RevisionID = max(RevisionID) + 1 from Disk_HIST
 where MachineID = @MachineID and InstanceKey = @InstanceKey IF (@RevisionID = NULL) 
 select @RevisionID = 1 
 insert into Disk_HIST (MachineID, InstanceKey, TimeKey, RevisionID) 
 select @MachineID, @InstanceKey, @TimeKey, @RevisionID 
   delete from Disk_DATA where MachineID = @MachineID and InstanceKey = @InstanceKey 
   END 
 return 
  END 
 END 
GO

Help me, please

Custom MOF entry for single reg key value; IE

Thu, 07 May 2009 20:35:18 Z

My initial goal was to tap into the below reg key to determine the installed IE version:

Local\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Internet Exploer\Version

But instead,

I used Sherry Kissinger's Mini Monster MOF Builder (extremely useful tool!) to build the language. I just have a few questions as how to go about doing this properly.

1st off here is the code for sms_def.mof:

[SMS_Report(TRUE), SMS_Group_Name("Internet_Explorer"), SMS_Class_ID("SMSExpert|Internet_Explorer|1.0")]

Class Internet_Explorer : SMS_Class_Template

{

[SMS_Report(TRUE), KEY] string MachineName;

[SMS_Report(TRUE) ] string ActivePrinter;

[SMS_Report(TRUE) ] uint32 CipherStrength;

[SMS_Report(TRUE) ] string ContentAdvisor;

[SMS_Report(TRUE) ] string IEAKInstall;

[SMS_Report(TRUE) ] string IEName;

[SMS_Report(TRUE) ] string Language;

[SMS_Report(TRUE) ] string Path;

[SMS_Report(TRUE) ] string ProductID;

[SMS_Report(TRUE) ] string Version;

[SMS_Report(TRUE) ] string AutoProxyDetectMode;

[SMS_Report(TRUE) ] string AutoConfigURL;

[SMS_Report(TRUE) ] string Proxy;

[SMS_Report(TRUE) ] string ProxyOverride;

[SMS_Report(TRUE) ] string ProxyServer;

[SMS_Report(TRUE) ] string ConnectionPreference;

[SMS_Report(TRUE) ] uint32 EnableHttp11;

[SMS_Report(TRUE) ] uint32 ProxyHttp11;

[SMS_Report(TRUE) ] string TempInternetFilesFolder;

[SMS_Report(TRUE) ] string PageRefreshType;

};

And here is the code for Configuration.mof:

[JoinOn("MicrosoftIE_Summary.__Server = MicrosoftIE_LanSettings.__Server AND MicrosoftIE_Summary.__Server = MicrosoftIE_ConnectionSummary.__Server AND MicrosoftIE_Summary.__Server = MicrosoftIE_Cache.__Server"),

ViewSources{"SELECT __Server, ActivePrinter, CipherStrength, ContentAdvisor, IEAKInstall, Name, Language, Path, ProductID, Version FROM MicrosoftIE_Summary",

"SELECT __Server, AutoProxyDetectMode, AutoConfigURL, Proxy, ProxyOverride, ProxyServer FROM MicrosoftIE_LanSettings",

"SELECT __Server, ConnectionPreference, EnableHttp11, ProxyHttp11 FROM MicrosoftIE_ConnectionSummary",

"SELECT __Server, TempInternetFilesFolder, PageRefreshType FROM MicrosoftIE_Cache"},

ViewSpaces{"\\\\.\\root\\CIMV2\\Applications\\MicrosoftIE", "\\\\.\\root\\CIMV2\\Applications\\MicrosoftIE",

"\\\\.\\root\\CIMV2\\Applications\\MicrosoftIE", "\\\\.\\root\\CIMV2\\Applications\\MicrosoftIE"}, Dynamic : ToInstance, provider("MS_VIEW_INSTANCE_PROVIDER")]

Class Internet_Explorer

{

[PropertySources{"__Server", "__Server", "__Server", "__Server"}, key ] string MachineName;

[PropertySources{"ActivePrinter", "", "", ""} ] string ActivePrinter;

[PropertySources{"CipherStrength", "", "", ""} ] uint32 CipherStrength;

[PropertySources{"ContentAdvisor", "", "", ""} ] string ContentAdvisor;

[PropertySources{"IEAKInstall", "", "", ""} ] string IEAKInstall;

[PropertySources{"Name", "", "", ""} ] string IEName;

[PropertySources{"Language", "", "", ""} ] string Language;

[PropertySources{"Path", "", "", ""} ] string Path;

[PropertySources{"ProductID", "", "", ""} ] string ProductID;

[PropertySources{"Version", "", "", ""} ] string Version;

[PropertySources{"", "AutoProxyDetectMode", "", ""} ] string AutoProxyDetectMode;

[PropertySources{"", "AutoConfigURL", "", ""} ] string AutoConfigURL;

[PropertySources{"", "Proxy", "", ""} ] string Proxy;

[PropertySources{"", "ProxyOverride", "", ""} ] string ProxyOverride;

[PropertySources{"", "ProxyServer", "", ""} ] string ProxyServer;

[PropertySources{"", "", "ConnectionPreference", ""} ] string ConnectionPreference;

[PropertySources{"", "", "EnableHttp11", ""} ] uint32 EnableHttp11;

[PropertySources{"", "", "ProxyHttp11", ""} ] uint32 ProxyHttp11;

[PropertySources{"", "", "", "TempInternetFilesFolder"} ] string TempInternetFilesFolder;

[PropertySources{"", "", "", "PageRefreshType"} ] string PageRefreshType;

};

My thought process tells me to paste the above code in their respective *.mof files on the site server and follow the procedures for "Monitoring Changes" on Sherry's blog site http://www.myitforum.com/myITWiki/SCCMINV.ashx and these changes will be adopted by clients.

All I really need is the version of IE so will the below code work? I edited the above code so God knows if it'll work :)

sms_def.mof:

[SMS_Report(TRUE), SMS_Group_Name("Internet_Explorer"), SMS_Class_ID("SMSExpert|Internet_Explorer|1.0")]

Class Internet_Explorer : SMS_Class_Template

{

[SMS_Report(TRUE) ] string Version;

};

Configuration.mof:

ViewSources{"SELECT __Server, Version FROM MicrosoftIE_Summary"},

ViewSpaces{"\\\\.\\root\\CIMV2\\Applications\\MicrosoftIE", "\\\\.\\root\\CIMV2\\Applications\\MicrosoftIE",

"\\\\.\\root\\CIMV2\\Applications\\MicrosoftIE", "\\\\.\\root\\CIMV2\\Applications\\MicrosoftIE"}, Dynamic : ToInstance, provider("MS_VIEW_INSTANCE_PROVIDER")]

Class Internet_Explorer

{

[PropertySources{"Version", "", "", ""} ] string Version;

};

OSArchitecture captured in SCCM?

Mon, 23 Nov 2009 17:37:41 Z

Hello,

I noticed that SCCM is not collection inventory information for OSArchitecture (W32_OperatingSystem). In previous versions of Windows, the version of the OS was captured completely in the Caption (x86 or x64), but this is not true with Vista and Windows 2008. We are linking our CMDB to SQL data in the SCCM database, but it's making it difficult to determine the Architecture of the OS using this method.

Thanks!

Software Metering Report - Specific Copmuter

Fri, 20 Nov 2009 18:44:14 Z

I don't see this report built in and I am wondering if anyone has created one.

I want to be able to have a specific computer report that will give me all the usernames, usages, times for a specific metered application that was run only on a specific computer.

Any ideas?

Editing mof file in SCCM

Mon, 23 Nov 2009 12:37:06 Z

Dear All,

I have a question that how i can edit mof file in SCCM.
Is there any tool available.

Rakesh Kumar

Software Inventory frequency

Tue, 03 Nov 2009 16:23:56 Z

I am sure this spans a few different topic areas but I figured I'd ask first here.

What is a recommended frequency to run Software Inventories on my client agents? Right now the SCCM Site is still in a dev state, but will grow to have about 500 clients.

I have collections setup for each software package that we deploy and support. Under each of these we have a sub collection that is used to apply mandatory assignments to. We push out the advertisements both using AD security groups and by manually adding SCCM Systems to the collection (Via right click tools). This works great. The problem that I am facing is that it takes way to long for the system to then show up in the top level software collection as having the software installed. What I have done to get around this is to use the right click tools after a successful deployment and I execute a manual software inventory.

The software collection are membership based on Software Products.Product name.

My three thoughts were:
1. Do I increase the frequency that we run Software inventories?
2. Can I add a command line execution of the software inventory to run as part of the deployment command line?
3. Setup collections without using Software Products.Product name?

Thanks in advance

Phil

hardware inventory empty on resource explorer

Thu, 19 Nov 2009 03:59:26 Z

Hi,

1 of the SCCM client's hardware inventory is not shown on Resource Explorer. I checked the Inventoryagent.log, some of the collection failed as below. The client name is not exist in MP_hinv.log. What is the problem? Any idea?

InventoryAgent.log
Collection: Class "Win32_Vulnerability" does not exist out.    InventoryAgent    19/11/2009 9:52:49 AM    2172 (0x087C)
Collection: Namespace = \\.\root\cimv2; Query = SELECT __CLASS, __PATH, __RELPATH, DefaultIPGateway, DHCPEnabled, DHCPServer, DNSDomain, DNSHostName, Index, IPAddress, IPEnabled, IPSubnet, MACAddress, ServiceName FROM Win32_NetworkAdapterConfiguration; Timeout = 600 secs.    InventoryAgent    19/11/2009 9:52:49 AM    2172 (0x087C)
Collection: 39/53 inventory data items successfully inventoried.    InventoryAgent    19/11/2009 9:52:49 AM    2172 (0x087C)
Inventory: Collection Task completed in 9.657 seconds    InventoryAgent    19/11/2009 9:52:49 AM    2172 (0x087C)
Inventory: 14 Collection Task(s) failed.    InventoryAgent    19/11/2009 9:52:49 AM    2172 (0x087C)
Inventory: Temp report = C:\Windows\SysWOW64\CCM\Inventory\Temp\0535f160-9cbf-43a8-9dce-24d7c43e782c.xml    InventoryAgent    19/11/2009 9:52:49 AM    2172 (0x087C)
Inventory: Starting reporting task.    InventoryAgent    19/11/2009 9:52:49 AM    4752 (0x1290)
Reporting: 50 report entries created.    InventoryAgent    19/11/2009 9:52:50 AM    4752 (0x1290)
Inventory: Reporting Task completed in 0.375 seconds    InventoryAgent    19/11/2009 9:52:50 AM    4752 (0x1290)
Inventory: Successfully sent report. Destination:mp:MP_HinvEndpoint, ID: {E5677EE7-FC6E-4D71-ABA0-9D8DCFAE58D7}, Timeout: 80640 minutes MsgMode: Signed, Not Encrypted    InventoryAgent    19/11/2009 9:52:50 AM    4752 (0x1290)
Inventory: Cycle completed in 21.029 seconds    InventoryAgent    19/11/2009 9:52:56 AM    4752 (0x1290)
Inventory: Action completed.    InventoryAgent    19/11/2009 9:52:56 AM    4752 (0x1290)

Query IE6 computers for SP1 and SP2?

Tue, 10 Nov 2009 10:48:17 Z

Hi all,

I received a request to show a list of all computers still using IE6 in SCCM2007 divided into a sub-list for 'No SP', SP1 and SP2, but after hours of searching I still haven't found a way to do this.

Can anyone help me with this? Point me in the right direction?

Thanks in advance,

John

Capturing Virtual Machine (Hyper-V) for OSD

Fri, 20 Nov 2009 00:02:20 Z

Hi,

If I were to capture a Virtual Machine as reference computer for Windows server 2008. Then I would like to use the OS image to deploy to a physical server. Is that alright? What else I need to do? import the drivers of the physical server to a driver package?

SCCM inventory for product key

Sat, 24 May 2008 08:23:13 Z

Can SCCM be customized to collect product key for software installed in every machine?

Understand that product keys are something sensitive and it would be risky to capture and export it to a report. However, this is also very important for one of my customer to be able to track who is using what license key to install their software as users in their environment are sharing their license key whereby user A is using user B license key to install the OS. There are also users who are using fake license key. The IT administrator needs to do a manual check of the registry for every PC in order to identify who is using the fake / incorrect product key.

Hope you can help. Thanks.

Capturing Printer Serial Numbers

Tue, 17 Nov 2009 22:09:49 Z

Does anyone know of any edit to the mof files or scripts for effectively capture printer serial numbers? I know the information is available from HPJet Direct web software so it has to be stored somewhere.

MOF change not reporting but the WMI class is created...

Tue, 17 Nov 2009 15:28:33 Z

I am looking to report on the members of a local group. I took the MOF we used in SMS and tested in a lab and worked perfect, reports generate fine. This is only applicable for our XP machines, no vista or W3K.

In my production environment I am having problems however.

I compile the MOF on a pilot machine and initially the Win32_LocalGroup class was inventoried, as I could verify in inventory. log, but no data every appeared in the DB. The tables and views are created in the DB but there is no data. I thought it would just take some time.

I see the change in WMI using WBEMTEST, the Win32_localgroup is created, and i can see the instances or members.

This morning when i run hardware inventory, delta or full, the Win32_LocalGroup class is no longer inventoried now.
I’ve recompiled the MOF but the class is not being inventoried any longer.

Not sure what I am missing here, any ideas folks?

Finding Serial Keys used to install a software

Fri, 13 Nov 2009 03:35:39 Z

There is a Internet based company where every user has local admin rights on his desktop system. These user require such free hand to carry out their day to day work, but the company also wishes to do a software audit from time to time.

Using Software inventory in SCCM 2007, is it possible to discover the product/serial keys used to install a particular software on the SCCM clients?

BAD_DDRs caused by SMS_AD_USER_DISCOVERY_AGENT

Tue, 07 Apr 2009 18:43:39 Z

I have several Bad DDRs under my ddm.box. When I open them up with a text editor, I discovered they came from the SMS_AD_USER_Discovery_Agent. In the MP_RegistrationManager.log, I see multiple errors stating A client is trying to re-register with an administrator revoked certificate SMSID=GUID:<GUID NAME> Please help.

SCCM Report #65

Mon, 09 Nov 2009 16:50:03 Z

Having a problem with report #65. When looking for a specific program, it brings back 204 machines however, there are duplicate machine names in the list. How can I avoid seeing the duplicates?

Jed

Wake on LAN Part 2

Mon, 09 Nov 2009 20:11:41 Z

Does anyone already have an SMS query to populate all clients with wake on LAN enabled? There are views in the SQL database which you can use to retrieve this data. I am trying to build a query based collection.

Thanks!

Mayur

SMS Mof editing

Mon, 02 Nov 2009 01:23:32 Z

This is my first attempt at extending hw inventory for custom registry keys. We are using SMS 2003. I am trying to determine which machines were incorrectly imaged using a single processor hal image. I have found the key for this at: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Enum\Root\ACPI_HAL\0000. The values I am interested in are either the hardware id or device description. I have used M. Cochranes’ simple mof extensions for registry keys tool and have come up with the following mof extension:

#pragma namespace ("\\\\.\\root\\cimv2")

#pragma deleteclass("HALType", NOFAIL)

[DYNPROPS]

Class HALType

{

[key] string KeyName;

Uint32 ConfigFlags;

Uint32 Legacy;

Uint32 DeviceReported;

String Service;

String HardwareID;

String CompatibleIDs;

Uint32 Capabilities;

String ClassGUID;

String Class;

String Driver;

String Mfg;

String DeviceDesc;

};

[DYNPROPS]

Instance of HALType

{

keyname="SystemCenter.fr";

[PropertyContext("Local|HKEY_LOCAL_MACHINE\\SYSTEM\\CurrentControlSet\\Enum\\Root\\ACPI_HAL\\0000|ConfigFlags"),Dynamic,Provider("RegPropProv")] ConfigFlags;

[PropertyContext("Local|HKEY_LOCAL_MACHINE\\SYSTEM\\CurrentControlSet\\Enum\\Root\\ACPI_HAL\\0000|Legacy"),Dynamic,Provider("RegPropProv")] Legacy;

[PropertyContext("Local|HKEY_LOCAL_MACHINE\\SYSTEM\\CurrentControlSet\\Enum\\Root\\ACPI_HAL\\0000|DeviceReported"),Dynamic,Provider("RegPropProv")] DeviceReported;

[PropertyContext("Local|HKEY_LOCAL_MACHINE\\SYSTEM\\CurrentControlSet\\Enum\\Root\\ACPI_HAL\\0000|Service"),Dynamic,Provider("RegPropProv")] Service;

[PropertyContext("Local|HKEY_LOCAL_MACHINE\\SYSTEM\\CurrentControlSet\\Enum\\Root\\ACPI_HAL\\0000|HardwareID"),Dynamic,Provider("RegPropProv")] HardwareID;

[PropertyContext("Local|HKEY_LOCAL_MACHINE\\SYSTEM\\CurrentControlSet\\Enum\\Root\\ACPI_HAL\\0000|CompatibleIDs"),Dynamic,Provider("RegPropProv")] CompatibleIDs;

[PropertyContext("Local|HKEY_LOCAL_MACHINE\\SYSTEM\\CurrentControlSet\\Enum\\Root\\ACPI_HAL\\0000|Capabilities"),Dynamic,Provider("RegPropProv")] Capabilities;

[PropertyContext("Local|HKEY_LOCAL_MACHINE\\SYSTEM\\CurrentControlSet\\Enum\\Root\\ACPI_HAL\\0000|ClassGUID"),Dynamic,Provider("RegPropProv")] ClassGUID;

[PropertyContext("Local|HKEY_LOCAL_MACHINE\\SYSTEM\\CurrentControlSet\\Enum\\Root\\ACPI_HAL\\0000|Class"),Dynamic,Provider("RegPropProv")] Class;

[PropertyContext("Local|HKEY_LOCAL_MACHINE\\SYSTEM\\CurrentControlSet\\Enum\\Root\\ACPI_HAL\\0000|Driver"),Dynamic,Provider("RegPropProv")] Driver;

[PropertyContext("Local|HKEY_LOCAL_MACHINE\\SYSTEM\\CurrentControlSet\\Enum\\Root\\ACPI_HAL\\0000|Mfg"),Dynamic,Provider("RegPropProv")] Mfg;

[PropertyContext("Local|HKEY_LOCAL_MACHINE\\SYSTEM\\CurrentControlSet\\Enum\\Root\\ACPI_HAL\\0000|DeviceDesc"),Dynamic,Provider("RegPropProv")] DeviceDesc;

};

#pragma namespace ("\\\\.\\root\\cimv2\\SMS")

#pragma deleteclass("HALType", NOFAIL)

[SMS_Report(TRUE),SMS_Group_Name("HALType"),SMS_Class_ID("Custom|HALType|1.0")]

Class HALType: SMS_Class_Template

{

[SMS_Report(false),key] string KeyName;

[SMS_Report(false)] Uint32 ConfigFlags;

[SMS_Report(false)] Uint32 Legacy;

[SMS_Report(false)] Uint32 DeviceReported;

[SMS_Report(false)] String Service;

[SMS_Report(true)] String HardwareID;

[SMS_Report(false)] String CompatibleIDs;

[SMS_Report(false)] Uint32 Capabilities;

[SMS_Report(false)] String ClassGUID;

[SMS_Report(false)] String Class;

[SMS_Report(false)] String Driver;

[SMS_Report(false)] String Mfg;

[SMS_Report(TRUE)] String DeviceDesc;

};

After I run mofcomp, I receive the error : test.mof (15): error SYNTAX 0X8004400c: Expected property or method name.

I know I’m missing something, and am thinking maybe this key can’t be used in this way?

Any help would be appreciated.

Resource Explorer Software empty

Thu, 05 Nov 2009 11:03:31 Z

Hi all,

Got the following problem. When I start Resource explorer of a client than the software part is empty. This happens for all the clients.
The Hardware part is fine and it shows everything.

SCCM 2007 and all the rules are installed on one windows 2008 R2 server in mixed mode. SQL 2005 is installed on an other windows 2003 server.

Can anyone help me to get the software part working?

How can I compare the software inventory for a client on two dates

Wed, 04 Nov 2009 15:31:48 Z

Hi,

I'm trying to track the software my users are installing. Quite often when a user has a problem, after troubleshooting for many hours, you find out it was caused by some random application they have installed in the last week.
I would like to be able to use SCCM Software Inventory to run a report of current software, and the same report as of the week before. I could then complare the two reports to see what's changed. I can't see an easy way to view a historical software inventory report.
Is this possible in SCCM and if so how? Also, if anyone has a better idea on how to achieve the result with a different product please let me know your thoughts.

Thanks

Wake on LAN report?

Wed, 04 Nov 2009 20:54:05 Z

Does anyone know if its possible to create a SMS query to get the wake on LAN status on the client? The setting can be usually found either in BIOS or on the advanced settings of the NIC.

Mayur

Old Machine Query

Thu, 24 Sep 2009 15:12:15 Z

I'm trying to figure out how to write two queries:

1.) Return all machines that have not been discovered in X amount of days by the SMS_AD_SYSTEM_DISCOVERY_AGENT.
2.) Return all machines in collection x and the last heartbeat received from them.

Thanks

**EDIT**

So apparently the SMS_R_System.AgentTime field contains the last heartbeat discovery time, but when I select it, I get a bunch of other times as well. How can I isolate the heartbeat time from the AD discovery time or client registration time?

Report 64bit

Wed, 04 Nov 2009 14:44:30 Z

Hi,

im trying to find out which Computers in our environment can manage 64-Operating Systems. My query is following:

SELECT DISTINCT SYS.Netbios_Name0 FROM v_R_System SYS, v_GS_PROCESSOR PRO
WHERE
PRO.ResourceID = SYS.ResourceID AND PRO.AddressWidth0 = '64'
ORDER BY SYS.Netbios_Name0

But instead of a list of all Computers with AddressWidth0=64 i get all Computers with an existing installation of a 64 Bit Operating System.

I have to say that im not really familiar with SQL. Maybe one of the Gurus out there see what i am doing wrong.

Please advice

Ty

Change to SQL view v_R_System?

Wed, 04 Nov 2009 18:30:33 Z

In my SMS days, I found that I always had better reporting for the last logged on user from our discovery cycles using the view - as opposed to using v_GS_ComputerSystem, which only had information obtained during a HINV cycle, which if no user was logged into Windows, then no inventory would be gathered.

However, now with SCCM, we're finding that the view is getting last logged on user from the same table that the view v_GS_ComputerSystem does. Was there a change to the SQL view v_R_System from SMS 2003 to SCCM 2007? Or am I just mis-remembering?

Nick Moseley - SCCM Admin http://t3chn1ck.wordpress.com

CPU Sockets versus CPU Cores

Thu, 12 Mar 2009 18:15:51 Z

Currently SCCM reports the processor count based on the number of cores found.
Some software products (like SQL) are licensed based on the physical CPU sockets in a system.
Is there a way to show the physical CPU sockets per computer using AI or standard SCCM reports?

Conflict GUID records

Tue, 13 Oct 2009 16:11:20 Z

Hi,

I have rename all the client computer name recently, I realize that in the collection, I could see both entries for new and old computer name. But it's only old computer name acts as sccm client, the new computer name isn't sccm client. I tried to look for the conflict record, I click to merge the record, at the end I still see 2 entries but now it''s two new computer name entries! How could I do the clean up work. Should I enable the maintenance tasks such as delete inactive client, clear install flag? Anyway none of the client computer has inactive/obselete status. Please help to advice what I can do now. Thanks

Client does not report Windows updates status

Fri, 30 Oct 2009 14:15:12 Z

I have a couple of servers, they do not report their software updates list to the SCCM Site. It looks like a WMI problem, because when installing the SCCM client, I get a number of WMI warnings in the Event Viewer, see below:

Event ID: 63

A provider, SMSDiskInstProvider, has been registered in the WMI namespace, root\cimv2\sms, to use the LocalSystem account. This account is privileged and the provider may cause a security violation if it does not correctly impersonate user requests.

Event ID: 5603

A provider, BcdProv, has been registered in the WMI namespace, root\wmi, but did not specify the HostingModel property. This provider will be run using the LocalSystem account. This account is privileged and the provider may cause a security violation if it does not correctly impersonate user requests. Ensure that provider has been reviewed for security behavior and update the HostingModel property of the provider registration to an account with the least privileges possible for the required functionality.

When I searching the SCCM client logs, I found the next messages:

Execmgr.log:

Software Distribution Site Settings for the client are missing from WMI.

InventoryAgent.log:

Collection: Class "Win32_PatchState_Extended" does not exist out.

I rebuild WMI but it did not help. Please help

Isolate the cause of dataldr error "attempt to update non-existent row. Invalid command: exec pWorkstationStatus_DATA"

Fri, 30 Oct 2009 15:18:25 Z

ConfigMgr SP1 with R2... all XP SP2 and SP3 advanced clients. We're collecting a few custom classes, and while monitoring the dataldr.log we're regularly seeing "rollbacks" with the error "attempt to update non-existent row" so I'm interested in narrowing the cause for this error.

In that case a given delta gets rejected and moved to badmifs folder, we inspect the serial number (Last Report Version) and the Last Hardware Scan (date/time) in the badmif and compare to the client record that’s in the database. 90% of the time, the last report version (serial number) and the last hardware scan date/time of the badmif are in sequence and logically follows what’s in the database (in other words, it seems that no inventory was missed).

The reason I ask is that *most* of the rejected delta MIFs have little more than Workstation_Status getting updated. The client is clearly in the database and an active client. Anyone have an idea on what’s causing the reject/rollback in this scenario? thank you, Al

SCCM AD System Discovery and Delete Aged Records

Tue, 20 Oct 2009 13:02:14 Z

I am in the process of deploying our SCCM Clients out to our Servers and Workstations. I have chosen the AD system Discovery + Client Push method. I pointed the discovery at the OU's where our Workstations and Servers are, it created records in the SCCM Database, and the clients have started to deploy.
As it is early days in our deployment, I have set the AD system discovery to run every three days to ensure that it detects all of our machines.

I am now faced with a bit of a mess in my All Systems Collection. I have a whole bunch of duplicate Computer Names, some with the agent = Yes and some without.

I had hoped that SCCM when running AD system discovery, would be able to match the computername and other attributes to the machines with agents already in the database, and be smart enough to not add these again to the database. This doesnt appear to be the case.

I am trying to find a happy medium between the AD System Discovery, and running the 'Delete Aged Discovery Data' task. If I have my AD system discovery set to run every 7 days, what would you recommend to set the Delete Aged Discovery Data task to? I am worried that the task will remove alot of valid information from my database based on what Technet mentions in this link http://technet.microsoft.com/en-us/library/bb693856.aspx

Anyone managed to find a happy medium?

Thanks,

- Scott.

Looking to see if there is a way to pull a history of hardware plugged into a PC

Wed, 21 Oct 2009 21:56:19 Z

To be specific I am not looking for the history of hardware inventories, I can pull those up in Resource Explorer for individual workstations. What I am looking for is to see if there is a way to pull a list of hardware that has been plugged into a PC, in this case USB drives.

Thanks.

SMS_SOFTWARE_INVENTORY_PROCESSOR 3701

Thu, 06 Nov 2008 18:19:19 Z

experts, I need you to help me, I get the following error ....

SMS Software Inventory Processor failed to process software inventory file "C:\Program Files\Microsoft Configuration Manager\inboxes\auth\sinv.box\ZTBT7G0B.SID," and has moved it to "C:\Program Files\Microsoft Configuration Manager\inboxes\sinv.box\BADSinv\pf10s1qd.SID."

Possible cause: The file attempted to update inventory information in the SMS site database that does not already exist, or the file contains invalid syntax.
Solution: The client inventory needs to be resynchronized, which will be done automatically. Look for the subsequent message 3703, which indicates the resynchronization has begun.

my English is not very good, hopefully I understand and can help me.

thanks.

Clients Approved N/A

Mon, 19 Oct 2009 20:35:25 Z

Hello All,

We have SCCM clients reporting Client: NO Approved: N/A and the site code is correct. The client property value is NULL. We've noticed that the property of machines with client value null….discovery data window has a grey background. Clients where the client property value is 0 have a white discovery data background.

Not sure if that matters.

Clients with N/A and client property value null can use remote tools just fine but are not updating their inventory data. I’ve check the few entries on this issue listed on this forum but I am not having any luck. The machines I’ve check are aware of their MP and are registered. Any help will be greatly appreciated.

Thanks

Software Metering - Custom Report

Wed, 21 Oct 2009 12:52:03 Z

Hi
I'm trying to add some extra infoemations to one of the standard Software Metering Reports.

declare @TimeKey int
declare @days float

set @TimeKey=100*@Year+@Month

select @days=DATEDIFF(day,IntervalStart,DATEADD(month,1,IntervalStart))
from v_SummarizationInterval where TimeKey=@TimeKey

if IsNull(@days,0) > 0
select mu.FullName,
       DATEADD(ss,@__timezoneoffset,MAX(mus.LastUsage)) as LastUsage,
       SUM(UsageCount) + SUM(TSUsageCount) as C021,
       ROUND((SUM(UsageCount) + SUM(TSUsageCount))/@days,2) as C022,
       ROUND(SUM(UsageTime)/60.0,2) as C023,
       ROUND(SUM(UsageTime)/60.0/(SUM(UsageCount) + SUM(TSUsageCount)),2) as C024,
       ROUND(SUM(UsageTime)/60.0/@days,2) as C025
from v_MeteredUser mu
join v_MonthlyUsageSummary mus on mu.MeteredUserID=mus.MeteredUserID
join v_MeteredFiles mf on mus.FileID=mf.MeteredFileID
where mf.ProductName = @RuleName
and mus.TimeKey = @TimeKey
group by mu.FullName
having SUM(UsageCount) + SUM(TSUsageCount) > 0
order by mu.FullName

I'm trying to customize the report so it will also show:

NetBios Name
Filename and Fileversion of the metered software
Inventoried file "%.xsd" on the machines

Explanation: The metered software is a softphone that provides telephony functionality and the filename *.xsd is actually the phonenumber on the client.

Normally, when I make custom reports, I "import" a standard report into SQL and then make the adjustments in there.
But I'm not able to "import" those "Software Metering" reports without getting some error messages.

I've tried to make the adjustments manually without any luck, just a lot of errors. And I'm not an SQL-expert.... ;-)

Best regards

Virtual Hosts - Hyper V & Virtual Server with version numbers

Thu, 22 Oct 2009 11:55:38 Z

I have a query which works for listing all the Virtual Server hosts along with domain, OS and version number - see below.
My question is how to I include Hyper-V servers as there is nothing in the Add/Remove programs for Hyper-V?

Select

sys.Netbios_Name0, sys.User_Domain0,

sys.Operating_System_Name_and0

arp

.DisplayName0, arp.Version0

FROM

v_R_System sys

JOIN

v_Add_Remove_Programs arp ON sys.ResourceID = arp.ResourceID

JOIN

v_FullCollectionMembership fcm on sys.ResourceID=fcm.ResourceID

WHERE

DisplayName0 like 'Microsoft Virtual Server 2005 R2%' and fcm.CollectionID='SMS000DS'

ORDER

BY sys.Netbios_Name0

What drive letters will be scanned during software inventory check

Fri, 26 Sep 2008 06:52:02 Z

Hi,

In additional to local Harddisk drive, will Floppy disk drive, CD/DVD drive, USB removable Hard drive and Network drive be scanned too?

Query all Core 2 due computers

Tue, 20 Oct 2009 13:35:21 Z

Hi

Is there any whay how to get query with all core 2 due processors? All modifications in one query. I need it for software distribution to install programm on all C2D machines.

Custom Report to show Boundary Description

Mon, 19 Oct 2009 10:46:32 Z

Hi

I have made the following report which shows "Netbios Names" and "user names" in a specific AD-site (Boundary).
But is it possible to also show the "Despription" of the Boundaries (the decription filled in when I create a new Boundary), f.ex. "Building 0" or "Country".

SELECT     TOP (100) PERCENT sys.Netbios_Name0 AS [Netbios Name], sys.User_Name0 AS [User Name], sys.AD_Site_Name0 AS [AD Site],
                      dbo.v_GS_OPERATING_SYSTEM.Caption0 AS [Operating System], dbo.v_GS_OPERATING_SYSTEM.LastBootUpTime0,
                      sys.Resource_Domain_OR_Workgr0 AS Domain
FROM         dbo.v_R_System AS sys INNER JOIN
                      dbo.v_AgentDiscoveries AS agent ON sys.ResourceID = agent.ResourceId INNER JOIN
                      dbo.v_GS_OPERATING_SYSTEM ON sys.ResourceID = dbo.v_GS_OPERATING_SYSTEM.ResourceID
WHERE     (sys.AD_Site_Name0 = @adsite)
GROUP BY sys.Netbios_Name0, sys.Resource_Domain_OR_Workgr0, sys.AD_Site_Name0, sys.User_Name0, dbo.v_GS_OPERATING_SYSTEM.Caption0,
                      dbo.v_GS_OPERATING_SYSTEM.LastBootUpTime0
ORDER BY [Netbios Name]

I found a table in the Database called "Boundary" but could'nt get it to work, when I try to implement in the report above.

Regards

I

Help with Report

Mon, 19 Oct 2009 06:01:17 Z

Hi

Can you help with Report. It conts MP3 files and i need to add to this report "v_GS_OPERATING_SYSTEM.Description0"

select Sys.Name0, Sys.User_Name0,
Count(SF.FileName) as FileCount,
Sum(SF.FileSize/1024/1024) as 'Wasted Megs'
from v_R_System Sys INNER JOIN v_GS_SoftwareFile SF on
Sys.ResourceID = SF.ResourceID
where SF.FileName like '%'+'.MP3' and SF.FileSize/1024/1024 > 0
Group by Sys.Name0, Sys.User_Name0
having Count(SF.FileName) > 50 order by Sys.Name0 Desc

but be siply adding it I got error "

Msg 8120, Level 16, State 1, Line 1

Column 'v_GS_OPERATING_SYSTEM.Description0' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause."

Create Custom-built Report

Mon, 19 Oct 2009 07:16:38 Z

Dear All

Our Customer want to create baseline report for inventory their hardware, they want to when they run report like they want to know now in their office how manay client that have CPU lower 2.0 GHz , RAM lower 1 GB , HDD size lower 30 GHZ, but there want to resoult is on same one report

please tell me how to create and what is SQL sommand that I will put on it

SCCM 2007 - Asset intelligence -> Custom reports (SW inventory) including product build / installation date

Mon, 12 Oct 2009 11:11:56 Z

Hello forum members,

If I am correct, SCCM 2007 has the Asset intelligence feature in order to produce SW inventory report. Actually, I have seen that specific inventory classes should be enabled for such kind of reports.

For instance, looking into reporting class descriptions listed for the software inventory- as posted at http://technet.microsoft.com/en-us/library/cc161933.aspx - although categorized & uncategorized installed (MS) software inventory could be reported, I was’t able to figure out how custom reports for product build, installation date, etc., could be generated.

Also, I was wondering, whether these custom reports could be applied on non-MS products, as well..

Is this something could be achieved via Custom Labels in Asset Intelligence, with which we can add our own information to the data that will be automatically be collected..?

If this is the case, any further reference or guidance, will be much appreciated.

Thanks in advance,

Greetings, Nick.