// *********************************************************************************
//
//  Created by SMS Export object wizard
//
//  Friday, March 27, 2009 created
//
//  File Name: Report.mof
//
// Comments :
//
//
// *********************************************************************************

// ***** Class : SMS_Report *****
[SecurityVerbs(140551)]
instance of SMS_Report
{
Category = "Software Distribution - Packages";
Comment = "Displays all distribution points for a specific package.";
DrillThroughColumns = {};


GraphCaption = "";
GraphXCol = 1;
GraphYCol = 2;
MachineDetail = FALSE;
MachineSource = FALSE;
Name = "All distribution points for a specific package (custom)";
NumPrompts = 1;
RefreshInterval = 0;

ReportParams = {
instance of SMS_ReportParameter
{
AllowEmpty = FALSE;
DefaultValue = "";
PromptText = "Enter PackageID";
SampleValueSQL = "begin
\n if (@__filterwildcard = '')
\n  SELECT DISTINCT PackageID, Name AS C062 FROM v_Package order by Name
\n else
\n  SELECT DISTINCT PackageID, Name AS C062 FROM v_Package
\n  WHERE PackageID like @__filterwildcard
\n  order by Name
\nend";
VariableName = "PackageID";
}};
SecurityKey = "";
SQLQuery = "SELECT 'INSTALLED'
\nSELECT \tpkg.Name,
\n                pkg.PackageID, 
\n                SUBSTRING(dp.ServerNALPath, CHARINDEX('\\\\', dp.ServerNALPath) + 2, CHARINDEX('\"]', dp.ServerNALPath) - CHARINDEX('\\\\', dp.ServerNALPath) - 3 ) as C070, 
\n                 dp.SiteCode
\nFROM v_Package pkg
\nLEFT OUTER JOIN v_DistributionPoint dp ON pkg.PackageID = dp.PackageID 
\nWHERE pkg.PackageID = @PackageID
\nORDER by C070
\n
\nSELECT 'NOT INSTALLED'
\nSELECT distinct SUBSTRING(ServerNALPath, CHARINDEX('\\\\', ServerNALPath) + 2, CHARINDEX('\"]', ServerNALPath) - CHARINDEX('\\\\', ServerNALPath) - 3 ) as C070, 
\n               v_DistributionPoint.SiteCode
\nFROM v_Package 
\nLEFT OUTER JOIN v_DistributionPoint ON v_Package.PackageID = v_DistributionPoint.PackageID
\nWHERE v_DistributionPoint.ServerNALPath NOT IN (SELECT v_DistributionPoint.ServerNALPath FROM v_DistributionPoint WHERE v_DistributionPoint.PackageID = @PackageID) and v_DistributionPoint.ServerNALPath IS NOT NULL
\nORDER by C070";
StatusMessageDetailSource = FALSE;
XColLabel = "";
YColLabel = "";
};
// ***** End *****