Advertisement
Guest User

Untitled

a guest
Sep 30th, 2012
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.95 KB | None | 0 0
  1. mysql> SELECT COUNT(*) FROM PnpQueue;
  2. +----------+
  3. | COUNT(*) |
  4. +----------+
  5. | 17977 |
  6. +----------+
  7. 1 row in set (0.00 sec)
  8.  
  9. mysql> SELECT SerialNumber, COUNT(*) FROM PnpQueue GROUP by Category;
  10. +-----------------------------------------------------------------------------------+----------+
  11. | SerialNumber | COUNT(*) |
  12. +-----------------------------------------------------------------------------------+----------+
  13. | /org/freedesktop/Hal/devices/usb_device_17ef_6014_noserial_if0_logicaldev_input | 20 |
  14. | /org/freedesktop/Hal/devices/pci_1002_5a14 | 13920 |
  15. | /org/freedesktop/Hal/devices/pci_10de_be3_sound_card_1_alsa_control__1 | 1090 |
  16. | /org/freedesktop/Hal/devices/storage_model_CDDVDW_SH_S202N | 70 |
  17. | \\192.168.80.131 | 2 |
  18. | /org/freedesktop/Hal/devices/computer_logicaldev_input | 450 |
  19. | /org/freedesktop/Hal/devices/net_00_08_54_aa_b3_df | 140 |
  20. | /org/freedesktop/Hal/devices/net_computer_loopback | 70 |
  21. | /org/freedesktop/Hal/devices/pci_10de_be3_sound_card_1_oss_mixer__1 | 484 |
  22. | /org/freedesktop/Hal/devices/acpi_CPU5 | 420 |
  23. | /org/freedesktop/Hal/devices/pci_1106_415_scsi_host_scsi_device_lun0_scsi_generic | 259 |
  24. | /org/freedesktop/Hal/devices/pci_1106_415_scsi_host | 819 |
  25. | /org/freedesktop/Hal/devices/usb_device_403_f850_noserial | 93 |
  26. | /org/freedesktop/Hal/devices/pci_10de_be3_sound_card_1 | 140 |
  27. +-----------------------------------------------------------------------------------+----------+
  28. 14 rows in set (0.00 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement