Microsoft

Microsoft Endpoint Configuration Manager Feedback

Suggestion box powered by UserVoice

guy sasson

My feedback

  1. 69 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Ideas » Reporting  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    guy sasson commented  · 

    hi ' this is sql query for your request: (tested on 1906 if you need for Other ver Tell me)
    _______
    SELECT DateTB.LastComplianceMessageTime AS 'Deploy Date', DplyDet.MachineID AS 'Machine ID', DplyDet.MachineName AS 'Computer Name', DplySum.Description AS 'Software',
    DplyDet.UserName AS 'Installed By', 'Success' AS 'AppStatusType', 'succeeded' AS 'EnforcementState', v_UserAppRequests.LastChangedBy
    FROM vAppDeploymentAssetDetails AS DplyDet INNER JOIN
    v_CICurrentComplianceStatus AS DateTB ON DplyDet.CurrentComplianceStatusID = DateTB.CI_CurrentComplianceStatusID INNER JOIN
    DeploymentSummary AS DplySum ON DplyDet.AssignmentID = DplySum.AssignmentID LEFT OUTER JOIN
    v_UserAppRequests ON DplySum.Description = v_UserAppRequests.DisplayName AND DplyDet.MachineName = v_UserAppRequests.Netbios_Name0
    WHERE (DplyDet.DeploymentIntent = 2) AND (DateTB.LastComplianceMessageTime > GETDATE() - 20) AND (DplyDet.StatusType = 1) AND (DplyDet.EnforcementState <> '1001') AND
    (DplyDet.CollectionName NOT LIKE N'APPS@*') AND (DplyDet.MachineName <> 'DateForViewStatus')
    _______
    if Installed By = (System) then the admin user deploy the software

    if LastChangedBy is not null , the admin use "Install Application" from the console - see : https://docs.microsoft.com/en-us/configmgr/apps/deploy-use/install-app-for-device

  2. 10 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Ideas » Deployment Monitoring  ·  Flag idea as inappropriate…  ·  Admin →
    guy sasson shared this idea  · 
  3. 1,020 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    43 comments  ·  Ideas » Application Management  ·  Flag idea as inappropriate…  ·  Admin →
    guy sasson supported this idea  · 
  4. 1,515 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    25 comments  ·  Ideas » Admin Console  ·  Flag idea as inappropriate…  ·  Admin →
    guy sasson supported this idea  · 
  5. 1,953 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    35 comments  ·  Ideas » Tools  ·  Flag idea as inappropriate…  ·  Admin →
    guy sasson supported this idea  · 

Feedback and Knowledge Base