Video Screencast Help
Search Video Help Close Back
to help

any script available

Created: 21 Dec 2012 | Updated: 24 Dec 2012 | 9 comments
Mahendra Panchotiya's picture
0 0 Votes
Login to vote
This issue has been solved. See solution.

Any script to find the low disk data from symantec database?

Comments 9 CommentsJump to latest comment

Brian81's picture

Are you referring to clients or the SEPM server itself?

0
Login to vote
  • Actions
Mahendra Panchotiya's picture

I required the systems where SEP client installed but not picking latest update due to low disk space.

0
Login to vote
  • Actions
rs_cert's picture

We have a SQL query which you can use in (https://www-secure.symantec.com/connect/downloads/sep-content-distribution-monitor) that help you to find the hostname and diskspace size in single click from your sep DB...

Query

SELECT computer_name, AGENT.FREE_DISK/1048576 from SEM_AGENT as AGENT LEFT OUTER JOIN V_SEM_COMPUTER as COMP ON AGENT.COMPUTER_ID = COMP.COMPUTER_ID LEFT OUTER JOIN IDENTITY_MAP as ID_MAP ON ID_MAP.ID = AGENT.GROUP_ID where AGENT.FREE_DISK/1048576 < 1000 (you can able to change the last value 1000 as per you want)

SOLUTION
+2
Login to vote
  • Actions
Brian81's picture

GUP content monitor may work

0
Login to vote
  • Actions
Mahendra Panchotiya's picture

Ok. I will try the attach query.

0
Login to vote
  • Actions
Parks1's picture

Agrre with above shared comments. Those step help you.

0
Login to vote
  • Actions
Riya31's picture

Also you can use computer status report.

0
Login to vote
  • Actions