![]() So any advice on how I get it just to display the share once and how to reduce it so 2 decimal places would be great! Where tblDiskdrives.Size > 0 And tblAssetCustom.State = 1 Andīut it duplicates the Shared drives and I'm slightly unsure of how to reduce the percentages down to 2 decimal places, I've tried ROUND and CONVERT but couldn't quite make it work. Inner Join tblDiskdrives On tblAssets.AssetID = tblDiskdrives.AssetID ![]() Inner Join tblSharesUni On tblShares.ShareUniqueID = Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID Inner Join tblAssets On tblShares.AssetID = tblAssets.AssetID TblDiskdrives.Freespace / tblDiskdrives.Size * 100 As PercentageUsed TblDiskdrives.Size - tblDiskdrives.Freespace As UsedSpace, As I'm training one of my tasks has been to monitor the shared folders we have on the network and keep tabs on thier sizes. I have next to no experience with SQL and I'm in my first IT role.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |