• State Not Answered
  • Locked Locked
  • Replies 1 reply
  • Subscribers 25 subscribers
  • Views 509 views
  • Users 0 members are here
Options
Related
This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Drive Space Alerts

chinesinho

HI there!

I hope this question hasn't been asked/answered yet, if so...I couldn't find it, so I apologize in advance.  I do know that there are custom alerts for Disk Free Space which returns values of either % free or space free (in MB).  My question is: is there a way to set up a custom alert in Ignite DPA that also includes the total space for the drive(s)?  For example, if we get an alert that sends out an email stating that there is 10% free space left on the D: drive, it would be beneficial to have in the email how much the total space for that D: drive is without having to take extra steps to get that information?

Thank you emoticons_happy.png

  • 0

    sorry for my english

    I did create "metric custom" for viewer counter of driver space used, well i wrote next code, you try in dev

    this query return 1 If one driver > 5

    -----------------------------------------------------------------------------------------------------

    declare @drivers as table(ID int identity(1,1), Driver Varchar(5), GBLibres int)

    Insert  into @drivers (Driver, GBLibres)

    exec XP_FIXEDDRIVES

    select Estatus

    From (

    select

    Case when (GBLibres/1024) < 5  then 1 END as Estatus

    From @drivers ) as S

    Where s.Estatus is not null

    -----------------------------------------------------------------------------------------------------

SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.

SolarWinds Customer Success Center Certification Media Vault Link Accounts
About THWACK Blogs For Government Edit Settings Free Tools & Trials
Legal Documents Terms of Use Privacy California Privacy Rights Security Information
©2024 SolarWinds Worldwide, LLC. All Rights Reserved.