Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql> SELECT COUNT(*) FROM PnpQueue;
- +----------+
- | COUNT(*) |
- +----------+
- | 17977 |
- +----------+
- 1 row in set (0.00 sec)
- mysql> SELECT SerialNumber, COUNT(*) FROM PnpQueue GROUP by Category;
- +-----------------------------------------------------------------------------------+----------+
- | SerialNumber | COUNT(*) |
- +-----------------------------------------------------------------------------------+----------+
- | /org/freedesktop/Hal/devices/usb_device_17ef_6014_noserial_if0_logicaldev_input | 20 |
- | /org/freedesktop/Hal/devices/pci_1002_5a14 | 13920 |
- | /org/freedesktop/Hal/devices/pci_10de_be3_sound_card_1_alsa_control__1 | 1090 |
- | /org/freedesktop/Hal/devices/storage_model_CDDVDW_SH_S202N | 70 |
- | \\192.168.80.131 | 2 |
- | /org/freedesktop/Hal/devices/computer_logicaldev_input | 450 |
- | /org/freedesktop/Hal/devices/net_00_08_54_aa_b3_df | 140 |
- | /org/freedesktop/Hal/devices/net_computer_loopback | 70 |
- | /org/freedesktop/Hal/devices/pci_10de_be3_sound_card_1_oss_mixer__1 | 484 |
- | /org/freedesktop/Hal/devices/acpi_CPU5 | 420 |
- | /org/freedesktop/Hal/devices/pci_1106_415_scsi_host_scsi_device_lun0_scsi_generic | 259 |
- | /org/freedesktop/Hal/devices/pci_1106_415_scsi_host | 819 |
- | /org/freedesktop/Hal/devices/usb_device_403_f850_noserial | 93 |
- | /org/freedesktop/Hal/devices/pci_10de_be3_sound_card_1 | 140 |
- +-----------------------------------------------------------------------------------+----------+
- 14 rows in set (0.00 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement