Friday, September 18, 2015

for a single computer add or remove programs info

Select v_Add_Remove_Programs.DisplayName0, v_Add_Remove_Programs.Publisher0, v_Add_Remove_Programs.Version0
FROM v_Add_Remove_Programs
JOIN  v_R_System ON v_Add_Remove_Programs.ResourceID = v_R_System.ResourceID
WHERE v_R_System.Netbios_Name0 = @computername
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

SCCM to Tanium

SCCM transition Options: of course intune otherwise  Deployment, Patching - Tanium Image - Tazier Inventory - Tanium Remote Control - Zoom  ...

  • Pull Dp concept
    When a package is distributed to a PullDP, DistMgr creates a PkgXferMgr job and added to the queue. - PkgXferMgr processes the job and cre...
  • DP Content checking
    --DP content status: use sms SELECT     v_PackageStatusDistPointsSumm.PackageID,                       v_Package.Name, v_PackageStatusDi...
  • PowerShell script to check WDS Service status against of List of servers.
    Below is a PowerShell script, this will list WDS Service status against of List of servers. $InPutComputersList = get-content "c:\M...