Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql> SELECT COUNT(*) FROM PnpQueue;
- +----------+
- | COUNT(*) |
- +----------+
- | 18858 |
- +----------+
- 1 row in set (0.06 sec)
- mysql> SELECT SerialNumber, COUNT(*) FROM PnpQueue GROUP by Category;
- +------------------------------------------------------------------------------------+----------+
- | SerialNumber | COUNT(*) |
- +------------------------------------------------------------------------------------+----------+
- | /org/freedesktop/Hal/devices/volume_label_THE_DOORS_SOFT_PARADE | 35 |
- | /org/freedesktop/Hal/devices/pci_8086_2e20 | 8933 |
- | /org/freedesktop/Hal/devices/pci_10de_be4_sound_card_1_alsa_control__1 | 2923 |
- | /org/freedesktop/Hal/devices/storage_model_DVD_RW_AD_7240S | 99 |
- | \\192.168.80.2 | 1 |
- | /org/freedesktop/Hal/devices/computer_logicaldev_input | 1232 |
- | /org/freedesktop/Hal/devices/pci_168c_2b_rfkill_phy0_wlan | 109 |
- | /org/freedesktop/Hal/devices/leds_ath9k_phy0_assoc | 437 |
- | /org/freedesktop/Hal/devices/net_e0_cb_4e_ff_84_25 | 305 |
- | /org/freedesktop/Hal/devices/net_e0_b9_a5_66_10_0b | 109 |
- | /org/freedesktop/Hal/devices/net_computer_loopback | 207 |
- | /org/freedesktop/Hal/devices/pci_10de_be4_sound_card_1_oss_mixer__1 | 1430 |
- | /org/freedesktop/Hal/devices/ppdev_parport0 | 98 |
- | /org/freedesktop/Hal/devices/acpi_CPU3 | 828 |
- | /org/freedesktop/Hal/devices/pci_8086_3a20_scsi_host_scsi_device_lun0_scsi_generic | 404 |
- | /org/freedesktop/Hal/devices/pci_8086_3a20_scsi_host | 1226 |
- | | 66 |
- | /org/freedesktop/Hal/devices/pci_10de_be4_sound_card_1 | 414 |
- | /org/freedesktop/Hal/devices/volume_uuid_0000_0001 | 2 |
- +------------------------------------------------------------------------------------+----------+
- 19 rows in set (0.07 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement