convery bytes to gigabytes

kulastone

Does anyone know how to convert bytes to gigabytes with 3 decimal places when setting up alerts. I have the following setup in the alert message body:

Available Space on Drive: ${VolumeSpaceAvailable as Bytes}
Total Space on Drive: ${VolumeSize as Bytes}

But i want to show it as gigabytes with 3 decimal places.. any ideas anyone??

lchance

not sure if this would work, but maybe it's an idea to get you (and me) started. i'll try to get around to testing it for myself.

but how about using the variable ${SQL:_____} and build a conversion formula inside it to do your conversion of bytes to gigabytes?

i'd have to test this out, but it seems to me that it could work or come close to working.

this snippet is from the NPM Admin Guide :

 

${SQL:{query}} as shown in the following example that returns the results of the SQL query Select Count(*) From Nodes

:

${SQL:Select Count(*) From Nodes}  And now here's an example of something i found on MSDN to do calculations using SELECT. Maybe you can get the idea on what i'm trying to offer here by inserting your formula...This is the query that calculates the revenue for each product in each sales order.USE AdventureWorks ;
GO
SELECT 'Total income is', ((OrderQty * UnitPrice) * (1.0 - UnitPriceDiscount)), ' for ',
p.Name AS ProductName
FROM Production.Product p
INNER JOIN Sales.SalesOrderDetail sod
ON p.ProductID = sod.ProductID
ORDER BY ProductName ASC ;
GO