Advertisement
Guest User

Untitled

a guest
Sep 25th, 2012
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.23 KB | None | 0 0
  1. mysql> select count(*) from PnpQueue;
  2. +----------+
  3. | count(*) |
  4. +----------+
  5. | 14153 |
  6. +----------+
  7. 1 row in set (0.04 sec)
  8.  
  9. mysql> SELECT SerialNumber, COUNT(*) FROM PnpQueue GROUP by Category;
  10. +------------------------------------------------------------------------------- -----+----------+
  11. | SerialNumber | COUNT(*) |
  12. +------------------------------------------------------------------------------- -----+----------+
  13. | /org/freedesktop/Hal/devices/usb_device_46d_c503_noserial_if0_logicaldev_input | 73 |
  14. | 5VP9V3VG | 8314 |
  15. | /org/freedesktop/Hal/devices/pci_1002_4383_sound_card_0_alsa_control__1 | 1370 |
  16. | /org/freedesktop/Hal/devices/storage_model_DVD_RW_ND_1300A | 138 |
  17. | /org/freedesktop/Hal/devices/acpi_FAN | 74 |
  18. | \\192.168.80.135 | 3 |
  19. | /org/freedesktop/Hal/devices/computer_logicaldev_input | 706 |
  20. | /org/freedesktop/Hal/devices/net_00_1f_c6_c4_91_a2 | 212 |
  21. | /org/freedesktop/Hal/devices/net_computer_loopback | 138 |
  22. | /org/freedesktop/Hal/devices/pci_1002_4383_sound_card_0_oss_pcm_1 | 828 |
  23. | /org/freedesktop/Hal/devices/ppdev_parport0 | 138 |
  24. | /org/freedesktop/Hal/devices/acpi_CPU1 | 276 |
  25. | /org/freedesktop/Hal/devices/pci_1002_4380_scsi_host_scsi_device_lun0_scsi_gen eric | 286 |
  26. | /org/freedesktop/Hal/devices/pci_1002_4380_scsi_host | 1242 |
  27. | /org/freedesktop/Hal/devices/usb_device_10c4_ea60_0001 | 217 |
  28. | /org/freedesktop/Hal/devices/pci_1002_4383_sound_card_0 | 138 |
  29. +------------------------------------------------------------------------------- -----+----------+
  30. 16 rows in set (0.11 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement