DotVBS | Windows Systems Management

Shows you AD Sites for your Distribution Points. ----Begin SQL ---- Select SiteCode ' SMS Site', name0 'Name', AD_Site_Name0 'Servers Physical AD Site', IP _Addresses0 'Servers IP ' from dbo .v_R_ Systemjoin v_ SystemResourceListon name0 = servernameleft outer join dbo .v_RA_System_ IPAddresseson v_R_System.resourceid=v_RA_System_IPAddresses.resourceidwhere RoleName = ' SMS Distribution Point' order by SiteCode , name0 desc ----End SQL ----

The following will show you the size of your s oftware inventory table. Change the table name to view other table sizes. Replace yourSMSdbName with the name of your SMS database. ----Begin SQL ---- EXEC sp _ spaceused N'yourSMSdbName.dbo.SoftwareInventory'; ----End SQL ----