Inventory Solution 7.0 Database Schema
Created: 15 Dec 2008 | Updated: 08 Feb 2013 | 7 comments
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.
Article Filed Under:
Group Ownership:
Comments 7 Comments • Jump to latest comment
Inventory Solution 7.0 Database Schema, Part 4: Agentless Inventory is now available.
https://www-secure.symantec.com/connect/articles/inventory-solution-70-database-schema-part-4-agentless-inventory
Thanks for the great work Joel!
Will this be done for 7.1 as well?
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.
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.
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.
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
The following tables have been added in 7.1:
CompanyFilter: nvarchar(255)
VersionFilter: nvarchar(255)
SQLQueryFilter: ntext
IsUsageTracked: bit
TrackingStartDate: datetime
Processor Name: varchar(256)
If your issue has been addressed, please use the "Mark as Solution" link for the relevant thread.
Would you like to reply?
Login or Register to post your comment.