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.
The following tables have been added in 7.1:
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
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).
Yes, most of the content is applicable to 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...
Will this be done for 7.1 as well?
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!