Discovery and Inventory Group

 View Only

Inventory Solution 7.0 Database Schema 

Dec 15, 2008 07:37 PM

Has your management requested a report on specific Inventory data? Do you need to analyze your hardware to scope your upgrade budget for the coming fiscal year? Do you need a robust report of what Operating Systems, including updates, you have out in your environment? Whatever the reason, understanding the database structure of your Inventory, and having a handy reference to every data point, will enable you to meet these types if requirements.

 


 

Statistics
0 Favorited
7 Views
1 Files
0 Shares
1 Downloads
Attachment(s)
jpg file
6634.jpg   4 KB   1 version
Uploaded - Feb 25, 2020

Tags and Keywords

Comments

Dec 13, 2012 10:18 AM

The following tables have been added in 7.1:

Table Name Data class Name Column name and data type
Inv_Software_Product_License Software Product License IsLicensable: int
Inv_Software_Key_Executable Software Key Executable Hash: nvarchar(255)
Inv_SoftwareProductFilter SoftwareProductFilter NameFilter: nvarchar(255)
CompanyFilter: nvarchar(255)
VersionFilter: nvarchar(255)
SQLQueryFilter: ntext
Inv_Software_Execution Software Execution IsMetered: bit
Inv_Software_Product_Usage Software Product Usage UsageCount: int
IsUsageTracked: bit
TrackingStartDate: datetime
Inv_Software_Product_Version Software Product Version Version: nvarchar(50)
Inv_Software_Image Software Image ImageUrl: nvarchar(255)
Inv_Software_Product_State Software Product State IsManaged: int
Inv_Software_Component_ State Software Component State IsManaged: int
Inv_HW_Processor_Name_Windows HW Processor Name Windows Device ID: nvarchar(256)
Processor Name: varchar(256)

 

Dec 12, 2012 05:10 PM

Hi Kyle,

Unfortunately I'm not aware of any data beyond Machine usage. If that doesn't have the data you need, I'm not aware of where else to find it. I do know the base agent should be sending in log on and log off events. This is used to figure out who the Primary User is, etc.

-Joel

Dec 12, 2012 11:54 AM

Thanks Triinu, I figured that was probably the case.

Question to Joel or anyone really...we used the table "Inv_AeX_EU_Logon_Users" to help track which PCs a user logs on to, how frequently, etc.  This table seems to be missing in 7.x, so wondering if there is any suggestion on how to simulate this functionality.  I tried using the Inv_UG_User_Account_Windows data and a few other tables, but it seems like that data is global.  Basically I'm trying to track down which users use which computers most frequently.  I'm thinking I may be limited to the data in Inv_AeX_AC_Machine_Usage to get this sort of per-user, per-machine data, with no way to obtain the # of logons to that machine (which was again one of the proxies we used to determine if a user was temporarily using  a computer, or was more of a permanent user of it).

Dec 12, 2012 03:24 AM

Yes, most of the content is applicable to 7.1 as well.

Jul 02, 2012 01:52 PM

Hi Joel,

Is all (or most) of this article series applicable to 7.1 as well, understanding some tables may have some changes from 7;0 to 7.1...

Jan 24, 2011 04:10 PM

Will this be done for 7.1 as well?

Related Entries and Links

No Related Resource entered.