Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

Inventory Solution 7.0 Database Schema

Created: 15 Dec 2008 • Updated: 08 Feb 2013 | 7 comments
Language Translations
Joel Smith's picture
+14 14 Votes
Login to vote

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.

Comments 7 CommentsJump to latest comment

ziggy's picture

Will this be done for 7.1 as well?

+3
Login to vote
KSchroeder's picture

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...

Thanks,
Kyle
Symantec Trusted Advisor

For Forum threads, please click "Mark as Solution" if answered.
For all content, please give a thumbs up if you agree with or support the post.

0
Login to vote
Triinu Gross's picture

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

If your issue has been addressed, please use the "Mark as Solution" link for the relevant thread.

0
Login to vote
KSchroeder's picture

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).

Thanks,
Kyle
Symantec Trusted Advisor

For Forum threads, please click "Mark as Solution" if answered.
For all content, please give a thumbs up if you agree with or support the post.

0
Login to vote
Joel Smith's picture

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

Joel Smith
Symantec Services Group (SSE)
Sr. Principal Support Engineer

0
Login to vote
Triinu Gross's picture

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)

If your issue has been addressed, please use the "Mark as Solution" link for the relevant thread.

0
Login to vote