Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

SQL Query for low space in c drive

Created: 17 Jan 2013 • Updated: 17 Jan 2013 | 4 comments
This issue has been solved. See solution.

Hello All,

How we can check low space in c drive of all client machine's (Which are in SEPM) through  SQL query?

Comments 4 CommentsJump to latest comment

Ashish-Sharma's picture

 

Check Vikram Comments on this thread

https://www-secure.symantec.com/connect/forums/not...

 

USE sem5
SELECT count(*) 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 < 200
 
Check this thread
 
https://www-secure.symantec.com/connect/forums/find-low-disk-systems-count
https://www-secure.symantec.com/connect/forums/any-script-available

Thanks In Advance

Ashish Sharma

 

 

Ambesh_444's picture

Hi,

Please find the same.

This query will tell u that how many space available in your c drive..

 

USE sem5

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.status = '1' and agent.agent_version <> '11.0.6100.645' and 
AGENT.FREE_DISK/1048576 < 800

 

Thank& Regards,

Ambesh

"Your satisfaction is very important to us. If you find above information helpful or it has resolved your issue. Please don't forget to mark the thread as solved."

SOLUTION
Sumit G's picture

Agree with above comment, one more ption to find the low disk systems. Use the query in Sep Content Distribution Montior and find the low disk space system

https://www-secure.symantec.com/connect/downloads/new-sep-content-distribution-monitor-gup-health-checking

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 < 2000

Regards

Sumit G.

srt1's picture

Thank you very much all, Great Job !!!!!

I got my answer properly ..