Re: Obtaining the list of packages with various sorting

On 2023-03-23 12:11, Carlos E. R. wrote:

On 2023-03-23 11:50, Robert Webb via openSUSE Users wrote:

...

  On Thu, 23 Mar 2023 11:33:12 +0100, "Carlos E. R." <> wrote:

...

On 2023-03-23 10:23, Andrei Borzenkov wrote:

...

The sort field is easy to change, it is the first field. Let's try with "vendor":

rpm -q -a --queryformat "%{VENDOR}\t%{INSTALLTIME:day} \    %{BUILDTIME:day} %-30{NAME}\t%15{VERSION}-%-7{RELEASE}\t%{arch} \    %25{VENDOR}%25{PACKAGER} == %{DISTRIBUTION} %{DISTTAG}\n" \   | sort | cut --fields="2-" | tee rpmlist | less -S

or

rpm -q -a --queryformat "%{VENDOR};%{INSTALLTIME:day}; \    %{BUILDTIME:day}; %{NAME};%{VERSION}-%-7{RELEASE};%{arch}; \    %{VENDOR};%{PACKAGER};%{DISTRIBUTION};%{DISTTAG}\n" \   | sort | cut --fields="2-" --delimiter=\; \   | tee rpmlist.csv | less -S

Now, obtaining the current repository name I don't know. Perhaps obtaining, separately, a list of vendor vs repository name, and do the correlation on the list as a second phase.

Obtaining the list of repos: (marked as quoted because it allows long not wrapped lines in Thunderbird)

cer@Elesar:~> rpm -q -a --queryformat "%{VENDOR};%{VENDOR};%{PACKAGER};%{DISTRIBUTION};%{DISTTAG}\n" | sort | uniq --unique Google LLC;Google LLC;Chrome Linux Team ;(none);(none) (none);(none);Google Inc. (Linux Packages Signing Authority) ;(none);(none) (none);(none);NVIDIA Corporation ;(none);(none) (none);(none);openSUSE:Backports OBS Project openSUSE:Backports@build.opensuse.org;(none);(none) (none);(none);openSUSE Project Signing Key ;(none);(none) (none);(none);PackMan Project (signing key) ;(none);(none) (none);(none);Printing OBS Project ;(none);(none) (none);(none);X11 OBS Project ;(none);(none) openSUSE;openSUSE;https://bugs.opensuse.org;openSUSE:Leap:15.4:NonFree;(none) Packman;Packman;packman@links2linux.de;Multimedia / openSUSE_Leap_15.4;(none) cer@Elesar:~>

In the worst case, I can manually create a list of repositories corresponding to the above. "zypper lr" says:

# | Alias | Name | Enabled | GPG Check | Refresh ---+-----------------------------+---------------------------------------------------------------------+---------+-----------+-------- 1 | Ext_Packman | EXT Packman Repository | Yes | (r ) Yes | Yes 2 | LocalRPMs_15.3 | LocalRPMs_15.3 | Yes | ( p) Yes | Yes 3 | OBS:_Printing | OBS: Printing | Yes | (r ) Yes | Yes 4 | X11_Pantheon_Apps | X11:Pantheon:Apps | Yes | (r ) Yes | Yes 5 | google-chrome | google-chrome | Yes | (r ) Yes | Yes 6 | openSUSE-Leap-15.4-1 | openSUSE-Leap-15.4-1 | No | ---- | ---- 7 | repo-backports-debug-update | Update repository of openSUSE Backports (Debug) | No | ---- | ---- 8 | repo-backports-update | Update repository of openSUSE Backports | Yes | (r ) Yes | Yes 9 | repo-debug | Debug Repository | No | ---- | ---- 10 | repo-debug-non-oss | Debug Repository (Non-OSS) | No | ---- | ---- 11 | repo-debug-update | Update Repository (Debug) | No | ---- | ---- 12 | repo-debug-update-non-oss | Update Repository (Debug, Non-OSS) | No | ---- | ---- 13 | repo-non-oss | Non-OSS Repository | Yes | (r ) Yes | Yes 14 | repo-oss | Main Repository | Yes | (r ) Yes | Yes 15 | repo-sle-debug-update | Update repository with updates from SUSE Linux Enterprise 15 (Deb-> | No | ---- | ---- 16 | repo-sle-update | Update repository with updates from SUSE Linux Enterprise 15 | Yes | (r ) Yes | Yes 17 | repo-source | Source Repository | No | ---- | ---- 18 | repo-update | Main Update Repository | Yes | (r ) Yes | Yes 19 | repo-update-non-oss | Update Repository (Non-Oss) | Yes | (r ) Yes | Yes

I have something from Nvidia, but it is only "gpg-pubkey" packages. Maybe they should be filtered out first. -- Cheers / Saludos, Carlos E. R. (from Elesar, using openSUSE Leap 15.4)