Video Screencast Help

system status sql table?

Created: 11 Mar 2013 • Updated: 28 Apr 2013 | 10 comments
K.G's picture
This issue has been solved. See solution.

 

hi,

Are there anyone  have any query to take "Status" section?

i done most of the disks,smsq,services,task status,vss in one script.

I also want to add  system status section on the VAC. (errors,warnings..)

They stored In which sql table? you have any query?

thanks..

Operating Systems:

Comments 10 CommentsJump to latest comment

Advisor's picture

Do you mean the Status warnings related to Awaiting Index and Backup item count..

K.G's picture

yes,in the top of the VAC there is system status section we can see backup mode,awaiting items etc...

how can i check these data, i will write a script.

 

Advisor's picture

Its JournalArchive and WatchFile tables in Vault Store DB

GertjanA's picture

Just out of curiosity, have you seen this:

http://evdashboard.sourceforge.net/

This is made by JPRKnight, with contributions from several forum members. I have not used it myself, but believe that the users using this are very pleased with it. It might help you in writing your own monitoring tool (that sounds like what you are doing), or you might want to use this?

 

Thank you, Gertjan, MCSE, MCITP,MCTS, SCS, STS
Company: www.t2.nl

www.quadrotech-it.com

www.symantec.com/vision

SOLUTION
K.G's picture

thanks, i know ev dashbord.

But i also created a custum script now.

my script checking ; journal item count, backup mode ,disk size status, msmq size ,san certificate status ,server uptime , EV task status, EV services..

This script running scheduled and send me an email in 1 txt file.

Now i want to add status section ,these informations came from where ?if i can get these location i can also add to my script. (sql query, batch file....?)

thanks...

John Santana's picture

KG can you share your scrip here please :-)

Kind regards,

John Santana
IT Professional

--------------------------------------------------

Please be nice to me as I'm newbie in this forum.

K.G's picture

ok i'll create a new topic then share.

you have any idea with system status section?

thanks...

John Santana's picture

yes please, and update us all here so that we know where to go to ;-)

Kind regards,

John Santana
IT Professional

--------------------------------------------------

Please be nice to me as I'm newbie in this forum.

K.G's picture

Hi, I am still developping and testing ,

Are there anyone give me a help about system status section?

Rob.Wilcox's picture

I can / will help you - send me a direct message.