4 Replies Latest reply on Feb 10, 2011 1:33 PM by fry_rob_g

    Memory slots available

    Rookie

      Is there a way to see if I have memory slots available through the query tool in ldms.  I notice it shows how many.  I want to be able to tell if they are in use.

        • 1. Re: Memory slots available
          Rookie

          anyone

          • 2. Re: Memory slots available
            klevitan Specialist

            Try this:

            In the query select:  Computer.Memory.Slots.Memory Slot.Installed Size = 0 MB

             

            The Select Columns and include Computer.Memory.Slots.Memory Slot.Number

             

            This will return a list of all memory slots that do not have any memory in them.  A computer will show up multiple times if it has multiple empty slots.

             

            - Kurt

            • 3. Re: Memory slots available
              Apprentice

              I'd probably try and filter out (not sure how this works, really, even after using LD for a few years now) Socket Designation:SYSTEM ROM. Our dc7900s show 5 memory slots, 4 DDR2 and one of these.

              • 4. Re: Memory slots available
                Apprentice

                Kevin got it right. We use a similar query (posted below) when we need to identify if machines have slots available to upgrade. We keep records for 180 days so we filter off of machines which have updated in the last 30... exclude all the Apple machines and then just show the slot and what is installed. If you wanted an inventory value which showed 'available slots' it would be trivial to write a script that takes empty/full slots and writes the value to either the ldcustom.dat or registry for retrieval at inventory time.

                 

                <?xml version="1.0"?>
                &lt;ExportableContainer xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" LastSavedBy="" Revision="0" SourceCore="" Guid="fake" SaveType="Inherit"&gt;
                  <DuplicateReferences />
                  &lt;SyncEnabled&gt;No&lt;/SyncEnabled&gt;
                  &lt;LastSavedDate&gt;0001-01-01T00:00:00&lt;/LastSavedDate&gt;
                  <Name>RAMSLOTS</Name>
                  &lt;AssemblyVer&gt;9.0.2.59&lt;/AssemblyVer&gt;
                  <Items>
                    &lt;Exportable xsi:type="EQuery" LastSavedBy="" Revision="8" SourceCore="" Owner="" Guid="" SaveType="Inherit"&gt;
                      <DuplicateReferences />
                      &lt;SyncEnabled&gt;No&lt;/SyncEnabled&gt;
                      &lt;LastSavedDate&gt;2011-02-10T12:39:36.713-08:00&lt;/LastSavedDate&gt;
                      <Name>RAMSLOTS</Name>
                      <Groups>
                        <string></string>
                      </Groups>
                      &lt;AssemblyVer&gt;9.0.2.59&lt;/AssemblyVer&gt;
                      &lt;QueryType&gt;0&lt;/QueryType&gt;
                      &lt;Filter&gt;"Computer"."Memory"."Slots"."Number of Slots" EXISTS  AND "Computer"."Last Updated by Inventory Server" &gt;= "getdate() - 30" AND "Computer"."Type" &lt;&gt; "MAC"&lt;/Filter&gt;
                      &lt;QuerySQL&gt;SELECT DISTINCT A0.DISPLAYNAME, A2.SLOTNO, A2.INSTALLEDSIZE  FROM Computer A0 (nolock) LEFT OUTER JOIN Memory A1 (nolock) ON A0.Computer_Idn = A1.Computer_Idn LEFT OUTER JOIN MemorySlot A2 (nolock) ON A0.Computer_Idn = A2.Computer_Idn  WHERE (A1.NUMSLOTS IS NOT NULL AND A0.LASTUPDINVSVR &gt;= getdate() - 30 AND A0.Computer_Idn NOT IN (SELECT Computer_Idn FROM Computer WHERE TYPE=N'MAC'))   ORDER BY  A0.DISPLAYNAME&lt;/QuerySQL&gt;
                      &lt;QueryFields&gt;
                        &lt;QueryField&gt;
                          <Alias>Device Name</Alias>
                          <BNF>"Computer"."Display Name"</BNF>
                          <Qualifier />
                        &lt;/QueryField&gt;
                        &lt;QueryField&gt;
                          <Alias>Number</Alias>
                          <BNF>"Computer"."Memory"."Slots"."Memory Slot"."Number"</BNF>
                          <Qualifier />
                        &lt;/QueryField&gt;
                        &lt;QueryField&gt;
                          <Alias>Installed Size</Alias>
                          <BNF>"Computer"."Memory"."Slots"."Memory Slot"."Installed Size"</BNF>
                          <Qualifier />
                        &lt;/QueryField&gt;
                      &lt;/QueryFields&gt;
                      &lt;QuerySorts&gt;
                        <QuerySort>
                          <BNF>"Computer"."Display Name"</BNF>
                        &lt;/QuerySort&gt;
                      &lt;/QuerySorts&gt;
                    </Exportable>
                  </Items>
                &lt;/ExportableContainer&gt;

                1 of 1 people found this helpful