Screencasts - Hilfsvideos

SQL Query for low space in c drive

Created: 17 Jan. 2013 • Aktualisiert: 17 Jan. 2013 | 4 Kommentare
Dieses Problem wurde gelöst. Siehe Lösung.

Hello All,

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

Kommentare KommentareZum neuesten Kommentar

das Bild der Ashish-Sharmas

Check Vikram Comments on this thread

https://www-secure.symantec.com/connect/forums/notification-disk-space

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

das Bild der Ambesh_444s

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."

LÖSUNG
das Bild der Sumit Gs

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.

das Bild der srt1s

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

I got my answer properly ..