Video Screencast Help
Search Video Help Close Back
to help

SQL Query for low space in c drive

Created: 17 Jan 2013 | Updated: 17 Jan 2013 | 4 comments
srt1's picture
srt1
0 0 Votes
Login to vote
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?

Discussion Filed Under:
, ,

Comments 4 Comments • Jump to latest comment

Ashish-Sharma's picture
Ashish-Sharma
SQL Query for low space in c drive - Comment:17 Jan 2013 : Link

 

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

SEPM Knowledgebase Documents  

 

+1
Login to vote
  • Actions
Ambesh_444's picture
Ambesh_444 Partner Accredited
SQL Query for low space in c drive - Comment:17 Jan 2013 : Link

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

Please mark your thread as 'SOLVED' with the answer that helps you.

SOLUTION
+3
Login to vote
  • Actions
Sumit G's picture
Sumit G
SQL Query for low space in c drive - Comment:17 Jan 2013 : Link

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.

+1
Login to vote
  • Actions
srt1's picture
srt1
SQL Query for low space in c drive - Comment:17 Jan 2013 : Link

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

I got my answer properly ..

0
Login to vote
  • Actions