6 Replies Latest reply on Sep 8, 2014 10:47 AM by dblansky

    view all devices needing reboot

    Apprentice

      Is there a console view in the the web interface or in the console that will show devices that need rebooted for any reason?

        • 1. Re: view all devices needing reboot
          rdittman Apprentice

          There may be better ways to get want you want but here are a couple places we use.

           

          1. Use the Inspector feature - right click on the Core name at the top of your network view. Choose security and scroll down to Reboot Information. If you double click on the chart it will choose the devices that need to reboot.

           

           

          2. Add the "Reboot Needed" column to your column views.  1=Reboot Needed

           

           

          • 2. Re: view all devices needing reboot
            Specialist

            I am not seeing Reboot needed on my inspector - I have 9.5 unpatched - is there a way to add it?

            • 3. Re: view all devices needing reboot
              rdittman Apprentice

              Could be wrong but I am pretty sure we had it with 9.5 unpatched. The info is located in the core.xml file on your core Program Files\ManagementSuite\inspectorWeb\Inspectors directory.

               

              Not sure if this is all of it but this appears to be the related section in the core.xml file.

               

              ---------

               

              </Controls>

                  </Expander>

                  <Expander Title="Reboot Information" ControlType="PieChart">

                   <Sql>

                    select distinct

                    (select count(l.RebootNeeded) FROM landesk l where l.RebootNeeded = '1') as needreboot,

                    (select count(l.RebootNeeded) FROM landesk l where l.RebootNeeded = '0') as dontneedreboot

                   </Sql>

                   <ChartSqlBreakdown>

                    <ChartData Title="Reboot Needed" SQL="SELECT Computer_Idn FROM landesk l where l.RebootNeeded = '1'" />

                    <ChartData Title="Reboot Not Needed" SQL="SELECT Computer_Idn FROM landesk l where l.RebootNeeded = '0'" />

                   </ChartSqlBreakdown>

                   <Controls>

                    <Control Title="Reboot Needed" Columns="needreboot"/>

                    <Control Title="Reboot Not Needed" Columns="dontneedreboot"/>

                   </Controls>

                  </Expander>

                  <Expander Title="Reboot Latency" ControlType="ColumnChart">

                   <Sql>

                    select

                    (select count(l.Computer_Idn) FROM landesk l where l.RebootNeededOn &lt;= #CURRENT_DATE#-0 and l.RebootNeededOn >= #CURRENT_DATE#-7) as zerotosevenday,

                    (select count(l.Computer_Idn) FROM landesk l where l.RebootNeededOn &lt;= #CURRENT_DATE#-8 and l.RebootNeededOn >= #CURRENT_DATE#-30) as eighttothirtydays,

                    (select count(l.Computer_Idn) FROM landesk l where l.RebootNeededOn &lt;= #CURRENT_DATE#-31 and l.RebootNeededOn >= #CURRENT_DATE#-60) as thirtyonetosixtydays,

                    (select count(l.Computer_Idn) FROM landesk l where l.RebootNeededOn &lt;= #CURRENT_DATE#-61) as oversixtyonedays

                   </Sql>

                   <ChartSqlBreakdown>

                    <ChartData Title="0-7 Days" SQL="select Computer_Idn FROM landesk l where l.RebootNeededOn &lt;= #CURRENT_DATE#-0 and l.RebootNeededOn >= #CURRENT_DATE#-7" />

                    <ChartData Title="8-30 Days" SQL="select Computer_Idn FROM landesk l where l.RebootNeededOn &lt;= #CURRENT_DATE#-8 and l.RebootNeededOn >= #CURRENT_DATE#-30" />

                    <ChartData Title="31-60 Days" SQL="select Computer_Idn FROM landesk l where l.RebootNeededOn &lt;= #CURRENT_DATE#-31 and l.RebootNeededOn >= #CURRENT_DATE#-60" />

                    <ChartData Title="61+ Days" SQL="select Computer_Idn FROM landesk l where l.RebootNeededOn &lt;= #CURRENT_DATE#-61" />

                   </ChartSqlBreakdown>

                   <Controls>

                    <Control Title="0-7 Days" Columns="zerotosevenday"/>

                    <Control Title="8-30 Days" Columns="eighttothirtydays"/>

                    <Control Title="31-60 Days" Columns="thirtyonetosixtydays"/>

                    <Control Title="61+ Days" Columns="oversixtyonedays"/>

                   </Controls>

                  </Expander>

                 </Expanders>

                </Tab>

              • 4. Re: view all devices needing reboot
                Specialist

                You can also create a query to look at wether the system is waiting for a reboot

                • 5. Re: view all devices needing reboot
                  Specialist

                  Thanks!  that did it - I now have the reboot in my inspector.

                  • 6. Re: view all devices needing reboot
                    Specialist

                    Yes - I added the column in my default layout & also built the query, but wanted to have this option also - I like the layout of the view there.