I often find myself peeking into Altiris databases with the goal of finding a particular piece of information. The only problem is, I rarely know what table it's stored in.
There are three options at this point,
- Stare vacantly at the database, scanning through every table name waiting for an internal bell to tinkle
- Google till you dribble
- Run a SQL Query to find your table
In case you are an option (3) type of admin, this is the query to use,
WHERE Name LIKE '%BIOS%'
WHERE Name like '%BIOS%'
Where here, in this instance, I'm looking for tables and views whose name includes the string "BIOS". This is a truely invaluable little query, and very helpful when trying to update reports across database versions. It's even quite handy if you simply are feeling a bit nosey.