For a specific Advertisement status for last 3 Days…

—for a specific Advertisement status for last 3 Days… if we include the Set   @AdvName = ‘%’ line then and remove the above line in red color will show for all advertisements with last 3 days status — To include all we need to give % in SQL this is a tip Declare     @AdvName Varchar(256)Set   … Read more

Pop-up to Postpone the advertisement or allow user to interact with advertisement

there was good Script from Jörgen Nilsson for Pop-up to Postpone the advertisement or allow user to interact with advertisement https://ccmexec.com/2011/09/allow-the-user-to-postpone-installation-in-sccm/ Screenshots of how it will look at the client: If the user press Cancel: If the Process specified is running: Usage: Download the script: https://ccmexec.com/wp-content/uploads/2011/09/Prerun1.txt Create a Package in SCCM containing the prerun1.vbs file … Read more