| UseFull SQL Tables/ Views | Description / Use |
| v_Add_Remove_Programs | |
| v_Advertisement | |
| v_AdvertisementInfo | |
| v_ClientCollectionMembers | |
| v_Collection | |
| v_Collection | |
| v_ConfigurationItems | |
| v_DistributionPoint | |
| v_DistributionPointGroup | |
| v_GS_ADD_REMOVE_PROGRAMS | |
| v_GS_ADD_REMOVE_PROGRAMS_64 | |
| v_GS_COMPUTER_SYSTEM | |
| v_GS_DISK | |
| v_GS_Memory_Details0 | |
| v_GS_OPERATING_SYSTEM | |
| v_GS_PATCHSTATE | |
| v_GS_SERVICE | |
| v_GS_SoftwareProduct | |
| v_GS_SYSTEM | |
| v_GS_WORKSTATION_STATUS | |
| v_GS_X86_PC_MEMORY | |
| v_OS_Details | |
| v_Package | |
| v_PackageStatus | |
| v_Program | |
| v_Query | |
| v_R_System | |
| v_R_User | |
| v_R_UserGroup | |
| v_RA_System_IPAddresses | |
| v_RA_System_IPSubnets | |
| v_RA_System_IPXAddresses | |
| v_RA_System_MACAddresses | |
| v_RA_System_SMSAssignedSites | |
| v_RA_System_SMSInstalledSites | |
| v_RA_System_SystemContainerName | |
| v_RA_System_SystemGroupName | |
| v_RA_System_SystemOUName | |
| v_RA_System_SystemRoles | |
| v_Report | |
| v_Site | |
| v_SiteBoundary_ADSite | |
| v_SiteBoundary_IPSubnet | |
| v_StateNames | |
| v_UpdateBundles | |
| v_UpdateListStatus_Live | |
| v_UpdatePrograms |
