Is it possible to use workflow to send an email when the drive being used by a logical volume is getting full?
Or does this have to be done via Windows tools on the LF server?
It is possible by using a SQL query on the repository database to add up the sizes of all the files, but I wouldn't recommend it because it would be pretty time consuming to fine tuning the runs of the query to catch the volume early enough for you to act on without running the query too often to protect SQL performance.
Windows/disk monitoring tools would be more suited for it.
Thank you Miruna!
We've done this by setting the maximum logical volume size to be slightly less than the size of the drive. Then we schedule a workflow to run daily which queries VOL table and checks the value of the CURDISKSIZE column for the newest rollover volume. If the CURDISKSIZE value is 95% of the max size that we set, we send an email letting us know that the volume is almost full.
At that point we create a new drive and manually change the drive letter of the logical volume so that the next volume gets created on this new drive.