jnelson993
Posts: 899
Score: 127
Joined: 2/18/2005
From: Minneapolis, MN
Status: offline
|
That report's purpose is to show you how the deployment did. It wasn't intended to have machines disappear if they were successful. If it did that, you wouldn't be able to use it to show mgmt that you got your 90% success rate (or whatever).
However, if you want to modify the report so that it does that, about all you have to do is add a parameter to the report to get a collectionID and then include a little SQL to the report to exclude machines from that particular collection.
declare @Total int
declare @Accepted int
select @Total=count(*), @Accepted=sum(case LastState when 0 then 0 else 1 end)
from v_ClientAdvertisementStatus
where AdvertisementID=@AdvertID
AND resourceID NOT IN (SELECT ResourceID FROM v_FullCollectionMembership WHERE CollectionID = @CollID)
select LastAcceptanceStateName as C013, count(*) as C015,
ROUND(100.0*count(*)/@Total,1) as C016,
AdvertisementID
from v_ClientAdvertisementStatus
where AdvertisementID=@AdvertID
AND resourceID NOT IN (SELECT ResourceID FROM v_FullCollectionMembership WHERE CollectionID = @CollID)
group by LastAcceptanceStateName, AdvertisementID
select LastStateName as C017, count(*) as C015,
ROUND(100.0*count(*)/@Accepted,1) as C016,
AdvertisementID
from v_ClientAdvertisementStatus
where AdvertisementID=@AdvertID and LastState!=0
AND resourceID NOT IN (SELECT ResourceID FROM v_FullCollectionMembership WHERE CollectionID = @CollID)
group by LastStateName, AdvertisementID
_____________________________
Number2 (John Nelson)
MyITForum - Blog
MyITForum - Forum Posts
|
Printable Version
Advertisement Reporting - 
New Messages
No New Messages
Hot Topic w/ New Messages
Hot Topic w/o New Messages
Locked w/ New Messages
Locked w/o New Messages
Post New Thread