One report which only lists the shares and one report which lists disk drives on your network computers. We don't scan the size of shared folders. 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 kommentar(er)
