Inventory ODBC?

myITforum.com Community Forum

Home Forums Blogs Live Support chat Search Articles Wiki FAQ Email Lists Register Login My Profile Inbox Address Book My Subscription My Forums

Photo Gallery Member List Search Calendars FAQ Ticket List Log Out

All Forums RSS Feed Subscription:

Inventory ODBC?

View related threads: (in this forum | in all forums)

Logged in as: Guest

Printable Version

All Forums >> [Management Products] >> System Center Products >> System Center Configuration Manager >> Inventory ODBC?

Page: [1]

Message

<< Older Topic Newer Topic >>

Inventory ODBC? - 9/30/2008 2:08:43 PM

bholwerda299

Posts: 7
Score: 0
Joined: 5/10/2006
Status: offline

Is it possible to add all the data sources on a computer to either the hardware or software inventory in SCCM?

Post #: 1

RE: Inventory ODBC? - 9/30/2008 2:34:09 PM

skissinger

Posts: 2293
Score: 145
Joined: 9/13/2001
From: Sherry Kissinger
Status: offline

Check out dwertzd's edit.

_____________________________

mofmaster@smsexpert.com (version 2007) | http://www.smsexpert.com | http://www.sccmexpert.com
My Blog
Microsoft MVP - ConfigMgr

(in reply to bholwerda299)

Post #: 2

RE: Inventory ODBC? - 10/2/2008 11:59:23 AM 1 votes

mhudson

Posts: 559
Score: 12
Joined: 4/1/2007
From: College Station, TX
Status: offline

------------------- Configuration.MOF-------------------------------
#pragma namespace ("\\\\.\\root\\cimv2")
[ dynamic,
provider("RegProv"),
ClassContext("local|HKEY_LOCAL_MACHINE\\SOFTWARE\\ODBC\\ODBC.INI")
]
class ODBC_Connections
{
    [Key] string DSN;
    [PropertyContext("Database")]
           string Database;
    [PropertyContext("Description")]
           string Description;
    [PropertyContext("Server")]
           string Server;
};
------------------------------------------------------------------------

------------------- sms_def.MOF-------------------------------
//**************************************************************************
//* Class: Registry for ODBC
//* Derived from: (nothing)
//*
//* Key = Name, Version
//*
//* This registry class provides information on ODBC information for the machine
//*
//**************************************************************************
[SMS_Report      (TRUE),
SMS_Group_Name   ("ODBC System DSN"),
SMS_Class_ID     ("OAI|ODBC System DSN|1.0")]
class ODBC_Connections : SMS_Class_Template
{
[SMS_Report(TRUE),Key]
      string DSN;
[SMS_Report(TRUE)]
      string Database;
[SMS_Report(TRUE)]
      string Description;
[SMS_Report(TRUE)]
      string Server;
};
------------------------------------------------------------------------

_____________________________

Matthew Hudson MCTS,MVP-ConfigMgr
http://sms-hints-tricks.blogspot.com/
http://www.sccm-tools.com

(in reply to skissinger)

Post #: 3