Client Management Suite

I would like to know about how to create reports for package servers package status for 7.1 Platform.

How are you defining the status, exactly?  What information do you want to know?  The status of a car might be defined as gear: Drive, Park, Neutral, Reverse, etc.  Or it might be defined as speed.  Or it might be speed and RPMs.  What factors are important to you when you say you want to know package server status?

We have package servers or site servers in more than 400 locations. We deliver  packages or software to all package servers or to the site servers through our deployment server. Then package servers delivers those software  or packages to the local PCs. 

We recently migrated from v6 to 7.1. In 6.x, we had a reporting filter for " Package Servers with Not Ready packages" . Based on this report we were able to know the status of software or package delivery failed or pass.

But in 7.1v we don't know how to create this filter under Reports\all Reports. Please let me know how it could be possible. Thanks.

Did you ever find an answer?  I'm looking for something similar.

Not seeing a canned one I could use (odd), I threw some SQL together after finding the appropriate table in the DB.

======================================================

select Server, [# Not Ready],[Disk Space-Mb] AS [Package Mb Missing]

from v_packagestatus

where [# Packages] = '0'

======================================================

At some point I'm going to add a join and add info re: the free disk space of the package share.

Sample output is attached (I think).

I like the column on disk space that is very useful in determining the status.  Here are a three reports I've been using for package status. 

I've been considering a report that will use the site servers package status log found on the package server.  I'd probably have to use Report Builder.  The datasource would be dynamic depending on the specific site server.  I'm not sure I'd need to do that since the column you listed on disk space would give the similiar information.

Shows Individual Package Status

SELECT r1.Name AS 'Server'
	,s2.Name AS 'Package'
	,s1.[Status]
	,s1.[Version]
	,r1.ModifiedDate AS 'Modified On'
	,s2.DistPointsLastUpdated
	,s2._Refreshed AS 'Refreshed'
	,r1.CreatedDate AS 'Create On'
FROM SWDPackageServer s1
INNER JOIN vResourceEx r1 ON s1.PkgSvrId = r1.Guid
INNER JOIN SWDPackage s2 ON s1.PackageId = s2.PackageId
	AND s2._Latest = 1
WHERE s2.Name LIKE '%PACKAGENAME%' AND
	r1.Name LIKE '%PACKAGESERVER%' AND
	s1.[Status] LIKE '%PACKAGESTATUS%'
ORDER BY r1.Name

Shows Package Summary by Package

SELECT p1.Name AS 'Package'
	,ISNULL(p2.Total, 0) AS 'Total'
	,ISNULL(p2.Ready, 0) AS 'Ready'
	,ISNULL(p2.Pending, 0) AS 'Pending'
	,ISNULL(p2.Invalid, 0) AS 'Invalid'
FROM vRM_Package_Item p1
LEFT JOIN (SELECT PackageId
		,COUNT(1) AS 'Total'
		,SUM(CASE WHEN [Status] = 'Ready' THEN 1 ELSE 0 END) AS 'Ready'
		,SUM(CASE WHEN [Status] NOT IN ('Invalid Package', 'Ready') THEN 1 ELSE 0 END) AS 'Pending'
		,SUM(CASE WHEN [Status] = 'Invalid Package' THEN 1 ELSE 0 END) AS 'Invalid'
	FROM SWDPackageServer
	GROUP BY PackageId) p2 ON p1.[Guid] = p2.PackageId
WHERE p1.Name LIKE '%PACKAGENAME%'

Shows the package summary by Site Server

SELECT r1.Name AS 'Server'
	,ISNULL(p1.Total, 0) AS 'Total'
	,ISNULL(p1.Ready, 0) AS 'Ready'
	,ISNULL(p1.Pending, 0) AS 'Pending'
	,ISNULL(p1.Invalid, 0) AS 'Invalid'
FROM vResourceEx r1
LEFT JOIN (SELECT PkgSvrId
		,COUNT(1) AS 'Total'
		,SUM(CASE WHEN [Status] = 'Ready' THEN 1 ELSE 0 END) AS 'Ready'
		,SUM(CASE WHEN [Status] NOT IN ('Invalid Package', 'Ready') THEN 1 ELSE 0 END) AS 'Pending'
		,SUM(CASE WHEN [Status] = 'Invalid Package' THEN 1 ELSE 0 END) AS 'Invalid'
	FROM SWDPackageServer
	GROUP BY PkgSvrId) p1 ON r1.[Guid] = p1.PkgSvrId
WHERE r1.Guid IN (SELECT DISTINCT PkgSvrId 
		FROM SWDPackageServer) AND 
	r1.Name LIKE '%PACKAGESERVER%'

Thanks EathenR for these reports but  I didn't succeed to apply the last report "package summary by Site Server" that interest me on CMS 7.1 SP1. It doen't give me any result.

Could someone know how to apply it on my platform?

Thanks in advance.