5 Replies Latest reply on Feb 21, 2017 1:15 PM by xtraspecialj

    Potential Oversight/Bug in SRM FileShare Alert "Available Fields" Options


      When building an Alert Trigger Condition or Inserting a Variable into an Alert Trigger Action for a SRM "File Share" object, the available Fields to select are quite thin, especially for a new state-of-the-art module like SRM.  I'd expect it to have at least the features of similar objects that other modules have, like a Used/Free space percentage field and especially a Status field.   I hope this is just an oversight that can be corrected.  There is indeed a File Share Status field in the FileShare table of the database, but you can't select it in the Alert selector (more on this later). 


      Surprisingly there is no Percentage field for file share usage in the database even though a calculated percentage value is shown in the web console.  That means somebody must have hard coded the percent calculation into the web code instead of having that data inserted into the DB (like it should be done) and pulling the data from there.  Data should never be calculated in web code.  It should always be put into a DB field and pulled from, otherwise there is no way for the user to access or manipulate the data (like in my case right here.)  Also, there isn't any way to set thresholds for individual File Shares that I can find.  Since there is no Percent used/free data kept for individual file shares, I guess it makes sense there is no individual thresholds feature available... 


      As far as the File Share Status, I'm honestly not sure what would cause a FileShare status to change since even though there is a Global Threshold for File Shares called "File System Used Capacity", I don't see any Percent used/free data kept in the SWQL tables except the "CapacityFileSystemPercentage" field in the SRM Volumes table.  A Volume is not a File Share.  Several File Shares can be on a Vfiler/Vserver's Volume.  I need to be able to threshold a File Share against it's Quota Percentage used.  The only time I would threshold a File Share against the entire Volume percent used would be for Shares that don't have quota's.  Even then I wouldn't threshold at the Volume level, I would threshold at the File Share level.  I don't see how the File Share percent thresholds even make sense the way they are now.


      I really hope I don't need to put in Feature Requests for this as this seems like the most basic thing that an object like this should have in any Orion module, much less a module that was just recently built. 


      As it stands now I have to build a custom SWQL condition that will have to calculate the percentage of a File Share's quota is used by adding the Used Space and Free Space together and dividing the Used Space by that Total, then have that percentage compared to the threshold. Since there is no Percent Threshold value for File Shares, I'm also going to have to build a custom property field called FileShareThreshold_Critical just so I can set Used Space Percentage thresholds on individual file shares without having the threshold value hard coded into the alert logic. 


      Please SolarWinds' SRM team, tell me you guys just forgot to include these trivial to implement yet very important features into your product and that you plan to correct this soon?  :-)