SELECT      dbo.SAFE_GUARD_DIR.SGD_NAME, dbo.SAFE_GUARD_DIR.SGD_DSN, dbo.IVT_INST_FEATURES.IIF_FEATURE, 
                      dbo.IVT_INST_FEATURES.IIF_FEATURE_VERSION, dbo.IVT_MACHINES.IMA_PBA, IVT_MACHINES_1.IMA_POA_TYPE, IVT_MACHINES_1.IMA_ENCRYPTED_DRIVES, 
                      IVT_MACHINES_1.IMA_UNENCRYPTED_DRIVES, IVT_MACHINES_1.IMA_LAST_SYNCHRONIZATION, IVT_MACHINES_1.IMA_LAST_POLICY_RECEIVED, 
                      dbo.USR_MACHINE_ASSIGN.UMA_IS_OWNER, dbo.USR_MACHINE_ASSIGN.UMA_TYPE, dbo.USERS.USR_LAST_NAME, dbo.USERS.USR_FIRST_NAME, 
                      dbo.USERS.USR_LOGON_NAME, dbo.USERS.USR_LOGON_DOMAIN, dbo.USERS.USR_EMAIL
FROM         dbo.IVT_INST_FEATURES INNER JOIN
                      dbo.IVT_MACHINES ON dbo.IVT_INST_FEATURES.IIF_MACHINE_ID = dbo.IVT_MACHINES.IMA_MACHINE_ID INNER JOIN
                      dbo.SAFE_GUARD_DIR ON dbo.IVT_MACHINES.IMA_MACHINE_ID = dbo.SAFE_GUARD_DIR.SGD_ID INNER JOIN
                      dbo.MACHINES ON dbo.SAFE_GUARD_DIR.SGD_ID = dbo.MACHINES.MAS_SDG_ID INNER JOIN
                      dbo.USR_MACHINE_ASSIGN ON dbo.MACHINES.MAS_SDG_ID = dbo.USR_MACHINE_ASSIGN.UMA_MACHINE_ID INNER JOIN
                      dbo.USERS ON dbo.USR_MACHINE_ASSIGN.UMA_USER_ID = dbo.USERS.USR_ID INNER JOIN
                      dbo.IVT_MACHINES AS IVT_MACHINES_1 ON dbo.IVT_INST_FEATURES.IIF_MACHINE_ID = IVT_MACHINES_1.IMA_MACHINE_ID AND 
                      dbo.SAFE_GUARD_DIR.SGD_ID = IVT_MACHINES_1.IMA_MACHINE_ID
ORDER BY dbo.SAFE_GUARD_DIR.SGD_NAME