[Veritas-bu] Advanced Reporter (different question)

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C34BEB.8C0A53A1
Content-Type: text/plain

Speaking of NBAR (in 4.5MP4)...I notice that the poolid column in the nbjobs
table is always set to 1.  Have others found that as well?
 
Unfortunately, the media_id column is set to blank if you use more than one
tape, which means that for many jobs it's impossible to determine from NBAR
what pool a job wrote to.
 
Veritas of course says "we don't support directly querying the database,"
even though they publish the schema...and provide example scripts...
 
Not that the schema is correct, of course.  Some of the columns have
incorrect names.
 
Gotta love NBAR.
 
-- 
 Drew Fabbro [fabbro.andrew AT cnf DOT com] 
 Unix Systems Group 
 Desk: 503-450-3374 
 Cell: 503-701-0369 

------_=_NextPart_001_01C34BEB.8C0A53A1
Content-Type: text/html

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=US-ASCII">
<TITLE>Message</TITLE>

<META content="MSHTML 6.00.2800.1170" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=157533922-16072003><FONT face=Arial color=#0000ff 
size=2>Speaking of NBAR (in 4.5MP4)...I notice that the poolid column in the 
nbjobs table is always set to 1.&nbsp; Have others found that as 
well?</FONT></SPAN></DIV>
<DIV><SPAN class=157533922-16072003><FONT face=Arial color=#0000ff 
size=2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=157533922-16072003><FONT face=Arial color=#0000ff 
size=2>Unfortunately, the media_id column is set to blank if you use more than 
one tape, which means that for many jobs it's impossible to determine from NBAR 
what pool a job wrote to.</FONT></SPAN></DIV>
<DIV><SPAN class=157533922-16072003><FONT face=Arial color=#0000ff 
size=2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=157533922-16072003><FONT face=Arial color=#0000ff 
size=2>Veritas of course says "we don't support directly querying the 
database," 
even though they publish the schema...and provide example 
scripts...</FONT></SPAN></DIV>
<DIV><SPAN class=157533922-16072003><FONT face=Arial color=#0000ff 
size=2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=157533922-16072003><FONT face=Arial color=#0000ff size=2>Not 
that the schema is correct, of course.&nbsp; Some of the columns have incorrect 
names.</FONT></SPAN></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT>&nbsp;</DIV>
<DIV><SPAN class=157533922-16072003><FONT face=Arial color=#0000ff size=2>Gotta 
love NBAR.</FONT></SPAN></DIV>
<DIV><FONT face="Courier New" size=2></FONT>&nbsp;</DIV>
<DIV><FONT face="Courier New" size=2>--</FONT> <BR><FONT face="Courier New" 
size=2>&nbsp;Drew Fabbro [fabbro.andrew AT cnf DOT com]</FONT> <BR><FONT 
face="Courier New" size=2>&nbsp;Unix Systems Group</FONT> <BR><FONT 
face="Courier New" size=2>&nbsp;Desk: 503-450-3374</FONT> <BR><FONT 
face="Courier New" size=2>&nbsp;Cell: 503-701-0369</FONT> </DIV></BODY></HTML>

------_=_NextPart_001_01C34BEB.8C0A53A1--