Re: license info stuff

[Marco Facchinetti <marco.facchinetti@xxxxxxxxx>]

Very nice, thanks.

--
Marco Facchinetti

Mr S.r.l.

Tel. 035 962885
Cel. 393 9620498

Skype: facchinettimarco


Il giorno mar 20 apr 2021 alle ore 15:01 Kevin Bucknum <
Kevin@xxxxxxxxxxxxxxxxxxx> ha scritto:

> Just to give you another option - most of what you are looking for shows
> up in here somewhere. Started with one of Scott Forstie's gists.
>
> SELECT s.host_name,
>        e.host_name,
>        'IBM i ' CONCAT os_version CONCAT '.' CONCAT os_release AS
> ibmi_level,
>        serial_number,
>        machine_type,
>        machine_model,
>        (SELECT processor_group
>                FROM qsys2.license_info
>                FETCH first ROW ONLY) AS processor_group,
>        (SELECT current_character_value
>                FROM QSYS2.SYSTEM_VALUE_INFO
>                WHERE system_value_name = 'QPRCFEAT') AS processor_feature,
>        ipl_mode,
>        ipl_type,
>        attention_light,
>        total_cpus,
>        e.configured_cpus,
>        configured_memory,
>        total_memory,
>        e.*,
>        s.*
>     FROM sysibmadm.env_sys_info e,
>          qsys2.system_status_info s;
>
>
> On Tue, 2021-04-20 at 12:00 +0000, Rob Berendt wrote:
>
> When a vendor asks you this
>
> System Serial Number  . . . . :
>
> System Model Number . . . . . :
>
> Processor Feature Code  . . . :
>
> Processor Group Number  . . . :
>
> Logical Partition Count . . . :
>
> Number of System Processors . :
>
> Number of Active OS Processors:
>
>
> What's an easy way to get all this?
>
> I'm kind of having a day and a SQL service isn't jumping up and down in
> front of me.  And searching IBM docs isn't helping this morning to find an
> appropriate API or some such thing.  Perhaps it's my newness with the new
> layout.
>
>
> Rob Berendt
>
> --
>
> IBM Certified System Administrator - IBM i 6.1
>
> Group Dekko
>
> Dept 1600
>
> Mail to:  7310 Innovation Blvd, Suite 104
>
>           Ft. Wayne, IN 46818
>
> Ship to:  7310 Innovation Blvd, Dock 9C
>
>           Ft. Wayne, IN 46818
>
> <http://www.dekko.com>
>
> http://www.dekko.com
>
>
>
>
>
> [https://www.medtronsoftware.com/img/MedtronMinilogo.bmp]  Kevin  Bucknum
>                    Senior Programmer Analyst
>                    MEDDATA / MEDTRON
>                    120 Innwood Drive
>                    Covington LA 70433
>                    Local: 985-893-2550
>                    Toll Free: 877-893-2550
>                  https://www.medtronsoftware.com
>
>
>
> CONFIDENTIALITY NOTICE
>
> This document and any accompanying this email transmission contain
> confidential information, belonging to the sender that is legally
> privileged.  This information is intended only for the use of the
> individual or entity named above.  The authorized recipient of this
> information is prohibited from disclosing this information to any other
> party and is required to destroy the information after its stated need has
> been fulfilled.  If you are not the intended recipient, or the employee of
> agent responsible to deliver it to the intended recipient, you are hereby
> notified that any disclosure, copying, distribution or action taken in
> reliance on the contents of these documents is STRICTLY PROHIBITED.  If you
> have received this email in error, please notify the sender immediately to
> arrange for return or destruction of these documents.
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com