Awesome.  Thanks for that SQL, Todd!

Sent from my Windows Phone
________________________________
From: Todd Hemsell<mailto:[email protected]>
Sent: ‎11/‎20/‎2014 5:35 PM
To: [email protected]<mailto:[email protected]>
Subject: Re: [mssms] Application Not in App Catalog

there is also some odd behavior around the available times. "sometimes" it
fills it out in local time, other times in GMT.
GO set the available time back by 24 hours.
Generally speaking they should show up in just a few minutes.

Here is some SQL you can run to see what would be returned to a specific
user if they went to the catalog


Select User_Name0,SID0 from V_R_User

get the user sid from above

If you are deploying to groups and not all users this will not work, you
would need to put the sid of all groups under the group sid section

exec [dbo].[usp_GetApplicationsTargetedToUser] @User=
N'S-1-5-21-3736358454-1868704084-1822373674-87276',

@UserGroupSids='',

@LocaleID=1033,

@SortColumnID=1,

@SortValue=0,

@SecondarySort=0,

@FilterCategoryValue=NULL,

@FilterPublisherValue=NULL,

@ClassicAppNameFields=2,

@StartRowIndex=340,

@TotalNumberOfRowsPerPage=20,

@SearchValue=N'',

@Featured=0

On Thu, Nov 20, 2014 at 4:32 PM, Jeff Poling <[email protected]>
wrote:

>  My original app was distributed to the correct DPs....everything was
> correct as far as I could tell.  I just could not get the deployment to
> show in the app catalog until I recreated the app.
>
> Jeff
>
> Sent from my Windows Phone
>  ------------------------------
> From: Todd Hemsell <[email protected]>
> Sent: ‎11/‎20/‎2014 4:30 PM
> To: [email protected]
> Subject: Re: [mssms] Application Not in App Catalog
>
>  they do not show up until it is on a DP.
>
> On Thu, Nov 20, 2014 at 3:44 PM, Dwayne Allen <[email protected]>
> wrote:
>
> I have no idea either.  Let us know if you figure something out.  I
> haven't had much luck
>
>  -----
> Dwayne Allen
> [email protected]
> (479) 310-0027
>
> On Thu, Nov 20, 2014 at 3:34 PM, Jeff Poling <[email protected]
> > wrote:
>
>  Well, I am still learning patience, so I went ahead and copied my
> application.  Then I deployed that new (really the same) app as available
> to the same collection.  The copied app now shows up in the app catalog. .
> . .
>
> I have no idea why that worked. . .any ideas on what logs or where I can
> look to see what went wrong with the original app/deployment?
>
> Thanks,
>
> Jeff
>
>  ------------------------------
> From: [email protected]
> Date: Thu, 20 Nov 2014 14:04:30 -0600
> Subject: Re: [mssms] Application Not in App Catalog
> To: [email protected]
>
>
> I have seen that before, assuming you've validated that your account is
> actually in the collection it is deployed to. :)  I've waited for hours for
> one to show up only to finally give up and go home and then it was there in
> the morning.  Sometimes it seems like you just have to go out an recreate
> the application.  You can try running 'exec usp_BuildCatalogPropertyTable'
> from SQL  If there is an DB issue rebuildling the catalog that will let you
> see it.  But I think under heavy load it can just take a while.
>
>  -----
> Dwayne Allen
> [email protected]
> (479) 310-0027
>
> On Thu, Nov 20, 2014 at 1:14 PM, Jeff Poling <[email protected]
> > wrote:
>
>  Feeling a little dumb here. . .I have an application in ConfigMgr 2012
> R2.  Single deployment type, user experience is set to install for system
> whether or not a user is logged in.  I deployed it to a user collection.
> The application is not showing in the application catalog after at least an
> hour.
>
> I can't find any reference to the application in the app*.log files. . .
>
> Has anyone seen this before? What am I missing?
>
> Thanks,
>
> Jeff
>
>
>
>
>
>
>
>
>
>






Reply via email to