Video Screencast Help
Search Video Help Close Back
to help
Not able to make it to Vision this year? Get a sampling in the Best of Vision on Demand group.

Need VBS Script for SEPM computer status report for past 24 hours

Created: 16 Sep 2011 | 13 comments
Ahdee's picture
0 0 Votes
Login to vote

i need VBS Script for SEPM console computer status report for past 24 hours, .csv or .txt file will automatically trigger to mail box on daily base.

Any one please help me on this.

Comments

Rafeeq's picture
16
Sep
2011
0 Votes 0
Login to vote

hi

if u create a schedule report in SEPM. it should have last check in time, u can sort it out,

Please don't forget to mark your thread solved with whatever answer helped you : ) Rafeeq

Ahdee's picture
20
Oct
2011
0 Votes 0
Login to vote

Sorry for delay response, I'm

Sorry for delay response,

I'm looking there is any SQL or batch script for automatically received mail with computer_status.txt or .csv file.

pete_4u2002's picture
20
Oct
2011
0 Votes 0
Login to vote

yes, the scheduled report

yes, the scheduled report will send an email to the user you intend to.

Ahdee's picture
24
Oct
2011
0 Votes 0
Login to vote

Sorry i'm not got you, could

Sorry i'm not got you, could you please how i can?

Ted G.'s picture
24
Oct
2011
0 Votes 0
Login to vote

How to configure Scheduled

How to configure Scheduled Reports:

https://imconsole-kb.ges.symantec.com/InfoManager/...

Symantec does not provide custom scripts or queries for customers.

Ahdee's picture
24
Oct
2011
0 Votes 0
Login to vote

Given link is not working!

Given link is not working!

Ahdee's picture
04
Nov
2011
0 Votes 0
Login to vote

Hi Vikram Thanks for the

Hi Vikram

Thanks for the link, but i'm looking for there is any script to send a mail with file attachment "computer staus log file".

 

 

Vikram Kumar-SAV to SEP's picture
04
Nov
2011
0 Votes 0
Login to vote

Yep..I know the VB Script you

Yep..I know the VB Script you are talking about..Let me see if I can find that.

Vikram Kumar-SAV to SEP's picture
04
Nov
2011
0 Votes 0
Login to vote
Ian_C.'s picture
07
Nov
2011
0 Votes 0
Login to vote

Interesting script

Hi Vikram.

That script looks very useful. Unfortunately, the sqlStr part ('select * from dbo.SEM_AGENT) is very basic. This will return all fields with ALL computers, deleted or not.

If that string could be expanded to something similar to https://www-secure.symantec.com/connect/articles/hardware-change-causes-re-registration-which-generates-multiple-entries-sep-clients-sepm-da#comment-5363071, then it would be usefull. maybe with a char(13) value for the new line character. Will have to try. Also, SEM_AGENT doesn't seem to have the name of the PC.

Ahdee's picture
16
Nov
2011
0 Votes 0
Login to vote

Hi Vikram, Thanks a lot for

Hi Vikram,

Thanks a lot for the script, is working good.

But i'm facing problem with, not able to get the report as look like "computer status.txt" could you please help me on this.

Ahdee's picture
28
Nov
2011
0 Votes 0
Login to vote

Hi Vikram, There is good

Hi Vikram,

 

There is any good news regarding the VBS script?