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 ---- About the Author Emmanuel Tsouris is a Systems Management veteran and Developer Advocate specializing in PowerShell and Cloud Automation. He maintains DotVBS to preserve legacy knowledge for the "archaeologist admin." Ready to move from VBScript to the Cloud? Check out his book, Pro PowerShell for Amazon Web Services . Vis...

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 ---- About the Author Emmanuel Tsouris is a Systems Management veteran and Developer Advocate specializing in PowerShell and Cloud Automation. He maintains DotVBS to preserve legacy knowledge for the "archaeologist admin." Ready to move from VBScript to the Cloud? Check out his book, Pro PowerShell for Amazon Web Services . Visit EmmanuelTsouris.com for his latest projects. As an Amazon Associate, I earn from qualifying purchases at no cost to you.