/bundles/itninjaweb/img/Breadcrumb_cap_w.png

Blog Posts tagged with K1000 Managed Installations (MI)

Ask a question

K1000 Reports - Tracking Managed Installs

K1000 Reports - Tracking Managed Installs
___________________________________________________________________________________

These four SQL reports allow the tracking of Managed Installs based on specified criteria.  Sometimes it's nice having a list of everything, but more frequently I need to check the status of things in progress or see what failed.  I've truncated example output so you can get a sample of all of the different statuses each report contains.

Just for the record, these are basically my tweaks on dchristian's Managed Installs report here:

http://www.itninja.com/question/managed-install-report

SELECT DISTINCT DATE_FORMAT(MI.CREATED,'%Y/%m/%d') as CREATED_DATE, S.DISPLAY_NAME, S.DISPLAY_VERSION,
CASE WHEN MS.MACHINE_ID > 0 THEN 'Installed'
WHEN MIA.ATTEMPT_COUNT > 0 THEN CONCAT('Not Installed (',MIA.ATTEMPT_COUNT,' of ', MI.MAX_ATTEMPT_COUNT,' attempts)')
ELSE 'Not Installed'
END  AS STATUS,
M.NAME, M.IP, M.LAST_SYNC, M.USER_NAME
FROM  SOFTWARE S
JOIN MI ON ( S.ID = MI.SOFTWARE_ID )
JOIN MI_LABEL_JT MIL ON ( MI.ID = MIL.MI_ID )
JOIN LABEL L ON ( MIL.LABEL_ID = L.ID )
JOIN MACHINE_LABEL_JT ML ON ( L.ID = ML.LABEL_ID )
JOIN MACHINE M ON ( ML.MACHINE_ID = M.ID )
JOIN SOFTWARE_OS_JT SO ON ( SO.SOFTWARE_ID = S.ID AND SO.OS_ID = M.OS_ID )
LEFT JOIN MACHINE_SOFTWARE_JT MS ON ( M.ID = MS.MACHINE_ID AND MS.SOFTWARE_ID = S.ID )
LEFT JOIN MI_ATTEMPT MIA ON ( MIA.MI_ID = MI.ID AND MIA.MACHINE_ID = M.ID )
ORDER  BY S.DISPLAY_NAME, S.DISPLAY_VERSION, STATUS
___________________________________________________________________________________

Notes on some of the CASE and WHERE statements I added to the reports:

MIA.ATTEMPT_COUNT = MI.MAX_ATTEMPT_COUNT means the maximum attempt count has been reached, which would indicate that the Managed Install failed.

MI.ENABLED != 0 means only enabled Managed Installs will be listed.

MI.UNINSTALL = 1 means the Managed Install is an uninstall-type Managed Install.
___________________________________________________________________________________
___________________________________________________________________________________

*Title*
Managed Installs - All Deployments

*Report Category*
Managed Installs (Custom)

*Description*
Lists all managed installs with status (Installed, Not Installed, Failed, Failed to Uninstall).  The 'Not Installed' status indicates the Managed Install has not started on the specified machines.

*SQL Select Statement*
select S.DISPLAY_NAME as MANAGED_INSTALL, S.DISPLAY_VERSION as SOFTWARE_VERSION, M.NAME as MACHINE,
case
when (MS.MACHINE_ID > 0 and MI.UNINSTALL = 0) then 'Installed'
when MIA.ATTEMPT_COUNT = MI.MAX_ATTEMPT_COUNT then 'Failed'
when (MS.MACHINE_ID > 0 and MI.UNINSTALL = 1) then 'Failed to Uninstall'
when MIA.ATTEMPT_COUNT > 0 then concat('Not Installed (',MIA.ATTEMPT_COUNT,' of ', MI.MAX_ATTEMPT_COUNT,' attempts)')
else 'Not Installed'
end as DEPLOYMENT_STATUS,
M.IP as 'IP Address', M.LAST_SYNC, M.USER_NAME as 'Last User'
from SOFTWARE S
join MI on (S.ID = MI.SOFTWARE_ID)
join MI_LABEL_JT MIL on (MI.ID = MIL.MI_ID)
join LABEL L on (MIL.LABEL_ID = L.ID)
join MACHINE_LABEL_JT ML on (L.ID = ML.LABEL_ID)
join MACHINE M on (ML.MACHINE_ID = M.ID)
join SOFTWARE_OS_JT SO on (SO.SOFTWARE_ID = S.ID and SO.OS_ID = M.OS_ID)
left join MACHINE_SOFTWARE_JT MS on (M.ID = MS.MACHINE_ID and MS.SOFTWARE_ID = S.ID)
left join MI_ATTEMPT MIA on (MIA.MI_ID = MI.ID and MIA.MACHINE_ID = M.ID)
order by MANAGED_INSTALL, SOFTWARE_VERSION, DEPLOYMENT_STATUS, MACHINE

Break on Columns:  MANAGED_INSTALL, SOFTWARE_VERSION
___________________________________________________________________________________

Title: Managed Installs - All Deployments
Description: Lists all managed installs with status (Installed, Not Installed, Failed, Failed to Uninstall). The 'Not Installed' status indicates the Managed Install has not started on the specified machines.
Category: Managed Installs (Custom)
Server Hostname: kbox.company.net
Generated: 2012/08/02 11:46:55

#   Machine    Deployment Status                Ip Address   Last Sync            Last User
1 of Managed Install: Adobe AIR, Software Version: 1.0.4990
 1  PPETERSON  Failed                           172.16.0.88  2012-08-02 10:03:36  ppeterso

3 of Managed Install: Adobe Flash Player 11 ActiveX, Software Version: 11.3.300.268
 2  AJONES     Installed                        172.16.1.42  2012-08-01 14:37:46  ajones
 3  CDANIELS   Not Installed                    172.16.3.77  2012-07-30 09:14:54  cdaniels
 4  DGREEN     Not Installed (1 of 3 attempts)  172.16.0.55  2012-08-02 09:05:49  dgreen

2 of Managed Install: Java(TM) 7 Update 5, Software Version: 7.0.50
 5  AJONES     Installed                        172.16.1.42  2012-08-01 14:37:46  ajones
 6  MWILLIAMS  Not Installed (1 of 3 attempts)  172.16.3.11  2012-08-02 09:58:52  mcwilliam

1 of Managed Install: Spelling Dictionaries Support For Adobe Reader 8, Software Version: 8.0.0
 7  jwhite     Failed to Uninstall              172.16.7.68  2012-08-02 10:26:13  jwhite
___________________________________________________________________________________
___________________________________________________________________________________

*Title*
Managed Installs - Enabled Deployments

*Report Category*
Managed Installs (Custom)

*Description*
Lists all enabled Managed Installs with status (Installed, Not Installed, Failed, Failed to Uninstall).  The 'Not Installed' status indicates the Managed Install has not started on the specified machines.

*SQL Select Statement*
select S.DISPLAY_NAME as MANAGED_INSTALL, S.DISPLAY_VERSION as SOFTWARE_VERSION, M.NAME as MACHINE,
case
when (MS.MACHINE_ID > 0 and MI.UNINSTALL = 0) then 'Installed'
when MIA.ATTEMPT_COUNT = MI.MAX_ATTEMPT_COUNT then 'Failed'
when (MS.MACHINE_ID > 0 and MI.UNINSTALL = 1) then 'Failed to Uninstall'
when MIA.ATTEMPT_COUNT > 0 then concat('Not Installed (',MIA.ATTEMPT_COUNT,' of ', MI.MAX_ATTEMPT_COUNT,' attempts)')
else 'Not Installed'
end as DEPLOYMENT_STATUS,
M.IP as 'IP Address', M.LAST_SYNC, M.USER_NAME as 'Last User'
from SOFTWARE S
join MI on (S.ID = MI.SOFTWARE_ID)
join MI_LABEL_JT MIL on (MI.ID = MIL.MI_ID)
join LABEL L on (MIL.LABEL_ID = L.ID)
join MACHINE_LABEL_JT ML on (L.ID = ML.LABEL_ID)
join MACHINE M on (ML.MACHINE_ID = M.ID)
join SOFTWARE_OS_JT SO on (SO.SOFTWARE_ID = S.ID and SO.OS_ID = M.OS_ID)
left join MACHINE_SOFTWARE_JT MS on (M.ID = MS.MACHINE_ID and MS.SOFTWARE_ID = S.ID)
left join MI_ATTEMPT MIA on (MIA.MI_ID = MI.ID and MIA.MACHINE_ID = M.ID)
where MI.ENABLED != 0
order by MANAGED_INSTALL, SOFTWARE_VERSION, DEPLOYMENT_STATUS, MACHINE

Break on Columns:  MANAGED_INSTALL, SOFTWARE_VERSION
___________________________________________________________________________________

Same output as Managed Installs - All Deployments report, but excludes disabled Managed Installs.
___________________________________________________________________________________
___________________________________________________________________________________

*Title*
Managed Installs - In Progress and Failed Deployments

*Report Category*
Managed Installs (Custom)

*Description*
Lists all enabled Managed Installs with deployments currently in progress, as well as those that failed (reached the maximum deployment attempt count) and failed to uninstall.

*SQL Select Statement*
select S.DISPLAY_NAME as MANAGED_INSTALL, S.DISPLAY_VERSION as SOFTWARE_VERSION, M.NAME as MACHINE,
case
when MIA.ATTEMPT_COUNT = MI.MAX_ATTEMPT_COUNT then 'Failed'
when (MS.MACHINE_ID > 0 and MI.UNINSTALL = 1) then 'Failed to Uninstall'
when MIA.ATTEMPT_COUNT > 0 then concat('Not Installed (',MIA.ATTEMPT_COUNT,' of ', MI.MAX_ATTEMPT_COUNT,' attempts)')
else 'Not Installed'
end as DEPLOYMENT_STATUS,
M.IP as 'IP Address', M.LAST_SYNC, M.USER_NAME as 'Last User'
from SOFTWARE S
join MI on (S.ID = MI.SOFTWARE_ID)
join MI_LABEL_JT MIL on (MI.ID = MIL.MI_ID)
join LABEL L on (MIL.LABEL_ID = L.ID)
join MACHINE_LABEL_JT ML on (L.ID = ML.LABEL_ID)
join MACHINE M on (ML.MACHINE_ID = M.ID)
join SOFTWARE_OS_JT SO on (SO.SOFTWARE_ID = S.ID and SO.OS_ID = M.OS_ID)
left join MACHINE_SOFTWARE_JT MS on (M.ID = MS.MACHINE_ID and MS.SOFTWARE_ID = S.ID)
left join MI_ATTEMPT MIA on (MIA.MI_ID = MI.ID and MIA.MACHINE_ID = M.ID)
where MI.ENABLED != 0
and MIA.ATTEMPT_COUNT != 0
order by MANAGED_INSTALL, SOFTWARE_VERSION, DEPLOYMENT_STATUS, MACHINE

Break on Columns:  MANAGED_INSTALL, SOFTWARE_VERSION
___________________________________________________________________________________

Title: Managed Installs - In Progress and Failed Deployments
Description: Lists all enabled Managed Installs with deployments currently in progress, as well as those that failed (reached the maximum deployment attempt count) and failed to uninstall.
Category: Managed Installs (Custom)
Server Hostname: kbox.company.net
Generated: 2012/08/02 11:39:31

#   Machine    Deployment Status                Ip Address   Last Sync            Last User
1 of Managed Install: Adobe AIR, Software Version: 1.0.4990
 1  PPETERSON  Failed                           172.16.0.88  2012-08-02 10:03:36  ppeterso

1 of Managed Install: Adobe Flash Player 11 ActiveX, Software Version: 11.3.300.268
 2  DGREEN     Not Installed (1 of 3 attempts)  172.16.0.55  2012-08-02 09:05:49  dgreen

1 of Managed Install: Java(TM) 7 Update 5, Software Version: 7.0.50
 3  MWILLIAMS  Not Installed (1 of 3 attempts)  172.16.3.11  2012-08-02 09:58:52  mcwilliam

1 of Managed Install: Spelling Dictionaries Support For Adobe Reader 8, Software Version: 8.0.0
 4  jwhite     Failed to Uninstall              172.16.7.68  2012-08-02 10:26:13  jwhite
___________________________________________________________________________________
___________________________________________________________________________________

*Title*
Managed Installs - Failed Deployments

*Report Category*
Managed Installs (Custom)

*Description*
Lists all enabled Managed Installs that failed (reached the maximum deployment attempt count) or failed to uninstall.

*SQL Select Statement*
select S.DISPLAY_NAME as MANAGED_INSTALL, S.DISPLAY_VERSION as SOFTWARE_VERSION, M.NAME as MACHINE,
case
when MIA.ATTEMPT_COUNT = MI.MAX_ATTEMPT_COUNT then 'Failed'
when (MS.MACHINE_ID > 0 and MI.UNINSTALL = 1) then 'Failed to Uninstall'
else 'Not Installed'
end as DEPLOYMENT_STATUS,
M.IP as 'IP Address', M.LAST_SYNC, M.USER_NAME as 'Last User'
from SOFTWARE S
join MI on (S.ID = MI.SOFTWARE_ID)
join MI_LABEL_JT MIL on (MI.ID = MIL.MI_ID)
join LABEL L on (MIL.LABEL_ID = L.ID)
join MACHINE_LABEL_JT ML on (L.ID = ML.LABEL_ID)
join MACHINE M on (ML.MACHINE_ID = M.ID)
join SOFTWARE_OS_JT SO on (SO.SOFTWARE_ID = S.ID and SO.OS_ID = M.OS_ID)
left join MACHINE_SOFTWARE_JT MS on (M.ID = MS.MACHINE_ID and MS.SOFTWARE_ID = S.ID)
left join MI_ATTEMPT MIA on (MIA.MI_ID = MI.ID and MIA.MACHINE_ID = M.ID)
where MI.ENABLED != 0
and (MIA.ATTEMPT_COUNT = MI.MAX_ATTEMPT_COUNT or MI.UNINSTALL = 1)
order by MANAGED_INSTALL, SOFTWARE_VERSION, DEPLOYMENT_STATUS, MACHINE

Break on Columns:  MANAGED_INSTALL, SOFTWARE_VERSION
___________________________________________________________________________________

Title: Managed Installs - Failed Deployments
Description: Lists all enabled Managed Installs that failed (reached the maximum deployment attempt count) or failed to uninstall.
Category: Managed Installs (Custom)
Server Hostname: kbox.company.net
Generated: 2012/08/02 11:36:46

#  Machine     Deployment Status    Ip Address   Last Sync            Last User
1 of Managed Install: Adobe AIR, Software Version: 1.0.4990
 1  PPETERSON  Failed               172.16.0.88  2012-08-02 10:03:36  ppeterso

1 of Managed Install: Spelling Dictionaries Support For Adobe Reader 8, Software Version: 8.0.0
 2  jwhite     Failed to Uninstall  172.16.7.68  2012-08-02 10:26:13  jwhite
___________________________________________________________________________________

Hope that helps!

John

View comments (8)

Fix for Error Uninstalling Program (Missing Source Files)

A handful of machines were failing uninstall-type Managed Installs (using Adobe's Uninstall, MSI uninstall commands, etc) and when trying to manually uninstall via Add/Remove Programs (which would give the annoying "missing source files" error).  I've used these tools several times now and found them to be very useful (particulaly since the error typically points to a Temp subfolder which got purged months/years ago).

Definitely beats purging the software by hand from the registry and manually deleting program folders/files (which is what I've done for many years).  The only thing improvement I would make would be to add an option to uninstall multiple applications in one shot, but other than that I can't complain.

These also have "Install Repair" functionality, but I can't speak for it since I haven't needed to use it yet.  Just FYI, it's there as well.

John
___________________________________________

XP & Vista
http://support.microsoft.com/kb/971187
* requires an active Internet connection, works with proxy via IE settings

Win7
http://support.microsoft.com/mats/Program_Install_and_Uninstall
* portable version of FixIt app available for download

View comments (3)

KACE: Deploying Adobe Acrobat X Standard

First you will need to use the Adobe Acrobat X Customization Wizard to create a MST file. You can find the wizard HERE.

Once you have done completed the customization add all of the installer files and the MST to a Zip file.

The files that should be included in the zip file are:

    - AcroStan.MSI

    - AcroStan.MST (your mst file)

    - Data1.cab

    - setup.exe

    - setup.ini

    - WindowsInstaller-KB893803-v2-x86.exe

Make sure when you create the Zip file that all of the files are in the root directory and not within a sub directory.

 

Next Create a new software inventory item and name it "Adobe Acrobat X Standard" or whatever you perfer.

    - Select all supported operating systems

    - Create a Custom inventory rule to look to see if Adobe X is installed.

EX:  For standard I used - FileExists(C:\Program Files\Adobe\Acrobat 10.0\Setup Files\{AC76BA86-1033-F400-BA7E-000000000005}) OR FileExists(C:\Program Files (x86)\Adobe\Acrobat 10.0\Setup Files\{AC76BA86-1033-F400-BA7E-000000000005})

and for Pro I used - FileExists(C:\Program Files\Adobe\Acrobat 10.0\Setup Files\{AC76BA86-1033-F400-7760-000000000005}) OR FileExists(C:\Program Files (x86)\Adobe\Acrobat 10.0\Setup Files\{AC76BA86-1033-F400-7760-000000000005})

Then associate the zip file we created earlier.

 

You can associate with a license if you like but it is not required.

Save and go to the distribution tab.

Under managed installs click the chose action box and chose "add new item"

From the software dropdown chose the software item you created earlier.

 

Under Installation Command check "Configure Manually"

Enter the following command: msiexec.exe /i AcroStan.msi TRANSFORMS=AcroStan.mst /quiet

Be sure to change AcroStan.mst to whatever you called your mst.

Check the Don't Prepend msiexe.exe

 

Now you can change the Managed action to whatever fits your needs, apply to the computers of your chosing and save.

That is it you are all set.

 

Feel free to ask questions if you need further help.

 

View comments (1)

Deploy a Microsoft Hotfix using a managed install in the K1000

Problem: Microsoft releases a hotfix (.msu file) that needs to be applied to systems that are vulnerable.

Solution: Use wusa.exe to install the .msu file through a K1000 managed install. For this example, KB2460922 was used.

 

  1. Download the hotfix file from Microsoft: http://support.microsoft.com/kb/2460922
  2. In this case, run the .exe file to extract the hotfix .msu file.
  3. Install the hotfix on a test machine and force a check-in/inventory update to the K1000.
  4. Upload the .msu file to the software inventory item titled "Hotfix for Microsoft Windows (KB2460922)". It will be under View By>Type>Patch Software.



  5. Select any operating systems you wish to deploy to in the software item.
  6. Create a MI using the following parameters:
    • Select "Hotfix for Microsoft Windows (KB2460922)" in the software drop-down.
    • Select the radio button for "Configure Manually".
    • For the installation command, use: wusa.exe /quiet /norestart Windows6.1-KB2460922-v2-x64.msu
      NOTE:
      To see how to get the options, see the section below the MI.
    • Check the box for "Don't Prepend msiexec.exe".
    • Set the managed action to "Execute Anytime".
    • Assign machines that need to have the hotfix applied.
    • Set any other parameters that are needed.
    • Save.

Once the targeted systems run the MI, the patch will show up in computer inventory under Software>Installed Patches via Inventory.

 

 

wusa.exe installer options:

From a command prompt, type wusa.exe and one of the following will give you the installer options:  /?, /h or /help

View comments (5)

K1000 Adobe Reader XI Deployment and Customization

Installation with a Managed Install 

 

To distribute Adobe  Reader 11 with the Dell KACE K1000 Appliance follow the steps below. 

Download the Adobe Reader 11 installation package.

 - ftp://ftp.adobe.com/pub/adobe/reader/win/11.x/11.0.00/en_US/AdbeRdr11000_en_US.msi 

Locate the software record for Adobe Reader XI in Inventory > Software

 -If one does not already exist we can create one. Before we can set up the Managed Installation, we must first have a listing for the program in Software Inventory. I recommend manually installing the program on a test box that has the KACE agent installed, and then forcing a check in. That’s the easiest way to create the item. 

Upload the Adobe Reader 11 MSI package under the associated files section of the software record. 

*Note: The MSI can be downloaded here- ftp://ftp.adobe.com/pub/adobe/reader/win/11.x/11.0.00/en_US/ 

Go to Distribution > Managed Installations and choose Add New Item from the Choose Action drop down menu. 

Choose Adobe Reader 11 from the software drop down menu. 

In the command section you can configure the install in two ways. 

You can leave "Use Default" checked and enter "/i /qn" in the field. 

Or you can choose "Configure Manually" and enter "msiexec.exe /I adberdr11000_en_US.msi /qn" in the field 

Configure your machine selection and managed action as needed. 

Save it and you are done.  The installation will deploy based on your choices above.

 

Customization of Adobe Reader XI

 

The installation of Adobe Reader can be customized with different command line switches as well.  You will need the EXE installer for these, which is also available from the FTP link above. 

/sAll Silent Mode for product

/sPB Silent Mode with Progress Bar for product

/rs Reboot Suppress

/rps Reboot Prompt Suppress

/ini "PATH" Alternative initialization file

/sl "LANG_ID" Set Language; LANG_ID - Code in decimal digits

/l Enable Error Logging.  Log file Bootstrap.log will be generated in temp directory

/msi[Command line] Parameters for MSIEXEC

 

Example Command Line (incorrect) AdobeReaderInstallFile.exe /sAll /rs /l /msi "/qb-! /norestart ALLUSERS=1 EULA_ACCEPT=YES SUPPRESS_APP_LAUNCH=YES"

 

This command line has parameters for both silent install (/sAll) as well as progress bar mode (/qb) which is useless. Also /rs and /norestart work the same way suppressing the reboot.

SUPPRESS_APP_LAUNCH=YES can also be removed as the checkbox for suppressing the application launch after install has been removed from the installer.

Moreover the quotes are not being recognized by the MSI Installer causing it to launch help window pop up. 

The command that can be used for silent install and suppressing EULA is:

AdobeReaderInstallFile.exe /sAll /msi /norestart ALLUSERS=1 EULA_ACCEPT=YES

View comments (3)
Showing 1 - 5 of 21 results

Top Contributors

Talk About Custom Ticket Rules