Registered member login:
Register Now
Altirigos » Altiris Administrators » General » Creating reports, need tables description

» Current Poll
Vista?
Staying on XP until Windows 7 - 72.14%
101 Votes
Already on Vista - 10.71%
15 Votes
Planning an upgrade to Vista soon - 10.00%
14 Votes
Other (please explain) - 7.14%
10 Votes
Total Votes: 140
You may not vote on this poll.
» Stats
Members: 6,831
Threads: 9,769
Posts: 47,815
Top Poster: Nick (4,800)
Welcome our newest member, jdh2000
» Online Users: 42
6 members and 36 guests
bretthexum, dclapp, DDoracin, jlevicke, JMoreno28, vpalisoc
Most users online at once 294, 06-30-2007 at 01:24 PM.
» January 2009
S M T W T F S
28293031 1 2 3
4 5 6 7 8 9 10
11 12 13 14 15 16 17
18 19 20 21 22 23 24
25 26 27 28 29 30 31
Reply
Old 07-05-2006, 07:45 AM   #1 (permalink)
 
Status: Junior Altiris Admin
Join Date: 07-05-2006
Location: St-Peterburg
Posts: 8


Creating reports, need tables description

Hi!
To create queries for reports I need full description of all objects (tables) available in query builder. Is there any manual with this information on www.altiris.com, because I could not find it by myself?

Thanks for your time.
goodman is offline   Reply With Quote
Old 07-05-2006, 08:43 AM   #2 (permalink)
 
Nick's Avatar
 
Status: Altiris Architect (Site Founder)
Join Date: 01-01-2005
Location: RDU, North Carolina, USA
Posts: 4,800


Closest thing you're going to find like that is in the back of the NS documentation. It's not much but it's the best thing available.
__________________
Scire potentia est (knowledge is power)
Nick is offline   Reply With Quote
Old 07-05-2006, 09:00 AM   #3 (permalink)
 
Status: Junior Altiris Admin
Join Date: 07-05-2006
Location: St-Peterburg
Posts: 8


Quote:
Originally Posted by Nick
Closest thing you're going to find like that is in the back of the NS documentation. It's not much but it's the best thing available.
But there is almost nothing in the NS user guide.
goodman is offline   Reply With Quote
Old 07-05-2006, 09:04 AM   #4 (permalink)
 
Nick's Avatar
 
Status: Altiris Architect (Site Founder)
Join Date: 01-01-2005
Location: RDU, North Carolina, USA
Posts: 4,800


I just pulled up the Reference manual from the documentation page. The section titled "Notification Database Schema" is the section I was referring to.

As I indicated, it isn't much but it is all that there is, that I am aware of.
__________________
Scire potentia est (knowledge is power)
Nick is offline   Reply With Quote
Old 07-05-2006, 09:17 AM   #5 (permalink)
 
Status: Junior Altiris Admin
Join Date: 07-05-2006
Location: St-Peterburg
Posts: 8


Quote:
Originally Posted by Nick
I just pulled up the Reference manual from the documentation page. The section titled "Notification Database Schema" is the section I was referring to.
But there is no description for any object field.
Thanks anyway, Nick.
goodman is offline   Reply With Quote
Old 07-05-2006, 03:29 PM   #6 (permalink)
 
loskeee's Avatar
 
Status: Super Altiris Admin
Join Date: 03-30-2006
Location: Atlanta GA
Age: 32
Posts: 357


Goodman if you come across that info can you please post it... I have been looking for that info also my next step is talking to Altiris im just using other options before I go to them...
loskeee is offline   Reply With Quote
Old 07-05-2006, 03:37 PM   #7 (permalink)
 
Nick's Avatar
 
Status: Altiris Architect (Site Founder)
Join Date: 01-01-2005
Location: RDU, North Carolina, USA
Posts: 4,800


What you are looking for is a data dictionary and there isn't one unless it has been done recently.

Best that I have been able to come up with is to create a query that gives me the names of each table/view and the columns present in each. I then import that into a spreadsheet for easy viewing.
__________________
Scire potentia est (knowledge is power)
Nick is offline   Reply With Quote
Old 07-24-2008, 07:22 PM   #8 (permalink)
 
Status: Junior Altiris Admin
Join Date: 07-17-2008
Location: Vancouver, Canada
Posts: 6


Schema

This is what I have, I hope it helps!
Attached Files
File Type: zip Altiris_Schema.zip (1.47 MB, 10 views)
Fast4wd is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Powered by vBadvanced CMPS v3.0 RC2

All times are GMT -4. The time now is 05:56 PM.


Powered by vBulletin® Version 3.7.4
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
vB.Sponsors
Altirigos