DarkAllien

SELECT *
       FROM [v_R_System] [s]
       WHERE [s].[ResourceID] IN
                                  (
                                  SELECT [c].[ResourceID]
                                         FROM [v_FullCollectionMembership] [c] WITH (nolock)
                                         WHERE [c].[CollectionID] = @CollID
                                  );

DarkAllien

SELECT *
       FROM [v_R_System] [s]
            JOIN
            (
            SELECT [c1].[ResourceID]
                   FROM [v_FullCollectionMembership] [c1] WITH (nolock)
                   WHERE [c1].[CollectionID] = @CollID
            ) [c] ON [c].[ResourceID] = [s].[ResourceID];

DarkAllien

USE [new database on SCCM DB Server];
GO

IF EXISTS
(
    SELECT *
    FROM sys.synonyms
    WHERE name = N'v_R_System'
          AND schema_id = SCHEMA_ID(N'dbo')
)

DarkAllien

USE [new database on SCCM DB Server];
GO

IF OBJECT_ID('[REP].[spSU_States_Update_Groups_per_Collection]', 'P') IS NOT NULL
    DROP PROCEDURE [REP].[spSU_States_Update_Groups_per_Collection];
GO
CREATE PROCEDURE [REP].[spSU_States_Update_Groups_per_Collection] @pCollID VARCHAR(8),
                                                                  @pSUGS   VARCHAR(4000)
AS
     BEGIN

DarkAllien

<?xml version="1.0" encoding="utf-8"?>
<Report xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns:cl="http://schemas.microsoft.com/sqlserver/reporting/2010/01/componentdefinition" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition">
  <AutoRefresh>0</AutoRefresh>
  <DataSources>
    <DataSource Name="AutoGen__5C6358F2_4BB6_4a1b_A16E_8D96795D8602_">
      <DataSourceReference>/ConfigMgr_VSM/{5C6358F2-4BB6-4a1b-A16E-8D96795D8602}</DataSourceReference>
      <rd:SecurityType>None</rd:SecurityType>
      <rd:DataSourceID>11111111-1111-1111-1111-111111111111</rd:DataSourceID>
    </DataSource>
  </DataSources>

DarkAllien

/*
declare @CollID varchar(8) = 'Collection ID for Testing'
DECLARE @UserSIDs VARCHAR(16);
SELECT @UserSIDs = 'disabled';
*/

declare @lcid as int set @lcid = dbo.fn_LShortNameToLCID('English')

--Getting Deployments IDs
select

DarkAllien

select CI_ID,title
FROM 
v_AuthListInfo
--Naming Filtering if you want it
where 
title like '%required%'
and title not like '%office%'
--and title not like '%pilot%'

DarkAllien

--DECLARE @UserSIDs VARCHAR(16) = 'disabled';
--DECLARE @CollID VARCHAR(8)= 'CollID for Testing';

declare @AuthListLocalID as int
select @AuthListLocalID=CI_ID from v_AuthListInfo 
where CI_UniqueID=@AuthListID

SELECT DISTINCT
       [rs].[NetBios_Name0] AS [Name],
       CASE

DarkAllien

declare @AuthListLocalID as int
select @AuthListLocalID=CI_ID from v_AuthListInfo
where CI_UniqueID=@AuthListID
SELECT distinct
ui.BulletinID,
ui.ArticleID,
ui.Title,
ui.Description,
ui.DateRevised,
    CASE ui.Severity