Oh, ok. What you might want to look at is
select *
from v_agentdiscoveries
where agentname = 'MP_ClientRegistration'
at an uninstall/reinstall, I'm pretty sure you get a new client
registration request to your MPs. The only tricky thing would be if you
have multiple primary sites--if a client moves from Sitecode ABC to XYZ,
the mp_clientRegistration on ABC might be months old; but the YXZ date for
mp_clientregistration will be recent.
On Tue, Sep 20, 2016 at 8:27 AM, Marcum, John wrote:
> My understanding is that creationdate is when the resource was added to
> the database. Something cause the client sdf file to corrupt on almost all
> my machines so I had to uninstall and reinstall every client. I’m trying to
> track down the ones that got missed.
>
>
>
> I found this select * from ClientPushMachine_G where Status = 4 and
> LatestProcessingAttempt
>
>
>
> But I think lastestProcessingAttempt is just the last time the ccr was
> attempted. I can’t find anything that is spefically client install date
>
>
>
>
>
>
>
> *From:* listsad...@lists.myitforum.com [mailto:listsadmin@lists.
> myitforum.com] *On Behalf Of *Daniel Ratliff
> *Sent:* Tuesday, September 20, 2016 7:46 AM
> *To:* mssms@lists.myitforum.com
> *Subject:* [mssms] RE: Find all clients not installed in last xx days
>
>
>
> *[This message is from outside Bradley. Exercise caution in opening
> attachments or links.]*
>
> Are you specifically looking for client push?
>
>
>
> How about client install date? Select CreationDate0 from v_r_system_valid
>
>
>
> *Daniel Ratliff*
>
>
>
> *From:* listsad...@lists.myitforum.com [mailto:listsadmin@lists.
> myitforum.com ] *On Behalf Of *Marcum,
> John
> *Sent:* Tuesday, September 20, 2016 8:26 AM
> *To:* mssms@lists.myitforum.com
> *Subject:* [mssms] Find all clients not installed in last xx days
>
>
>
> I need to create a report that shows all clients not installed in the past
> xx days. Looks like the data I need is in sp_CP_StatusDetail_AllSites. I
> see that is the stored procedure being using by the client push status
> details report. What I don’t know is how to use the stored procedure in a
> custom SQL query to get the info I need. Has anyone else done this?
>
>
> --
>
>
> Confidentiality Notice: This e-mail is from a law firm and may be
> protected by the attorney-client or work product privileges. If you have
> received this message in error, please notify the sender by replying to
> this e-mail and then delete it from your computer.
>
>
>
>
> The information transmitted is intended only for the person or entity to
> which it is addressed
> and may contain CONFIDENTIAL material. If you receive this
> material/information in error,
> please contact the sender and delete or destroy the material/information.
>
>
>
>
--
Thank you,
Sherry Kissinger
My Parameters: Standardize. Simplify. Automate
Blogs: http://www.mofmaster.com, http://mnscug.org/blogs/sherry-kissinger,
http://www.smguru.org
