I am looking for query c drive disk space information on my all machine. How to do that via report or query. I need queries for both

Toutes les réponses

• vendredi 17 février 2012 18:28

   

   
  

  0
  SELECT     TOP (100) PERCENT dbo.v_R_System.Name0 AS [System Name], dbo.v_GS_LOGICAL_DISK.Name0 AS [C Drive], dbo.v_GS_LOGICAL_DISK.Size0 AS [Total Size], 
                        dbo.v_GS_LOGICAL_DISK.FreeSpace0 AS FreeSpace, dbo.v_GS_LOGICAL_DISK.Size0 AS Used
  FROM         dbo.v_R_System INNER JOIN
                        dbo.v_GS_LOGICAL_DISK ON dbo.v_R_System.ResourceID = dbo.v_GS_LOGICAL_DISK.ResourceID INNER JOIN
                        dbo.v_FullCollectionMembership ON dbo.v_FullCollectionMembership.ResourceID = dbo.v_R_System.ResourceID
  WHERE     (dbo.v_GS_LOGICAL_DISK.DriveType0 = 3) AND (dbo.v_FullCollectionMembership.CollectionID = 'sms00001') AND (dbo.v_GS_LOGICAL_DISK.Name0 = 'c:')
  ORDER BY FreeSpace

  ---

  This posting is provided "AS IS" with no warranties or guarantees, and confers no rights. Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. Click on "vote as Helpful" if you feel this post helpful to you. This can be beneficial to other community members reading the thread.

  • Proposé comme réponse PaddyMaddy vendredi 17 février 2012 18:29
  • Marqué comme réponse Garth JonesMVP, Moderator samedi 10 novembre 2012 17:27
  •  
  • Réponse
  • Citation

   
• vendredi 17 février 2012 19:16

   

   
  

  0
   

  I am looking for which are parameter i need to select in criteria tab

  • Réponse
  • Citation