Altiris NS7 Database - File Details
There have obviously been some quite extensive database changes from NS6 to NS7. Many of our existing queries against the database no-longer work. I'm struggling to re-create a couple of my scripts, and I wonder if anyone has some pointers.
I pull out a list of the .EXE file details from the database, including filename, size, path and where available the .EXE header.
I can find the filename and path in the table Inv_Installed_File_Details, and what looks like the filesize in Inv_File_Details. If these are the correct tables, how are they linked?
Also, the .EXE file header details now seem to be within the item table. How can I link this back to the file details in Inv_Installed_File_Details?
Any pointers would be most appreciated.