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:listsad...@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:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Marcum, John
Sent: Tuesday, September 20, 2016 8:26 AM
To: mssms@lists.myitforum.com<mailto: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.



Reply via email to