Select Distinct VRS.Netbios_Name0,
VRS.ResourceID,
CS.ComplianceState,
CS.EnforcementState,
CS.AppModelName,
Apps.DisplayName,
Apps.NumberOfDevicesWithApp,
Apps.NumberOfDevicesWithFailure
From vAppClientState CS
Left Join v_R_System VRS ON CS.MachineID = VRS.ResourceID
Left Join fn_ListApplicationCIs(1033) Apps ON Apps.ModelName = CS.
AppModelName
Where DisplayName Is Not Null
Order By Netbios_Name0
On Mon, May 20, 2013 at 12:02 PM, Dzikowski, Michael <
[email protected]> wrote:
> I think I looked in the DB, all over the place to find that data, and I
> couldn’t…. ****
>
> ** **
>
> *From:* [email protected] [mailto:
> [email protected]] *On Behalf Of *Jitendra Kalyankar
> *Sent:* Monday, May 20, 2013 12:58 PM
> *To:* Todd Hemsell; [email protected]
> *Subject:* RE: [mssms] Create Collection using Application Information****
>
> ** **
>
> Never really looked in there but my educated guess is, this data comes
> from one of the summarization tasks or function. Will have to dig into that
> though.
>
> Jitendra
>
> Sent from my Windows Phone****
> ------------------------------
>
> *From: *Todd Hemsell <[email protected]>
> *Sent: *20-05-2013 22:15
> *To: *[email protected]
> *Subject: *[mssms] Create Collection using Application Information****
>
> Has anyone figured out how to build a collection using this data?****
>
> ****
>
> [image: Inline image 1]****
>
> ****
>
> ****
>
> ** **
>
>
<<image001.jpg>>
