SQL. Заметки на полях
01 Jan 2016
local_offer
SQL
local_offer
memo
Выборка свойств WMI класса
Используется в проекте Hardwareinfo.
SELECT tbComputerTarget.Name, tbInventoryClass.Name AS ClassName, tbInventoryProperty.Name AS PropertyName,
tbComputerInventory.Value, tbComputerInventory.InstanceId
FROM tbComputerInventory INNER JOIN
tbInventoryClass ON tbComputerInventory.ClassID = tbInventoryClass.ClassID INNER JOIN
tbInventoryProperty ON tbComputerInventory.PropertyID = tbInventoryProperty.PropertyID INNER JOIN
tbComputerTarget ON tbComputerInventory.ComputerTargetId = tbComputerTarget.ComputerTargetId
WHERE (tbComputerTarget.Name = 'l016.pshome.local');
Представления в БД Inventory
Используется в проекте Reports.
SELECT tbComputerTarget.Name AS `Name`, tbInventoryClass.Name AS `ClassName`, tbInventoryProperty.Name AS `PropertyName`, tbComputerInventory.Value AS `Value`, tbComputerInventory.InstanceId AS `InstanceId`
FROM (((tbComputerInventory
JOIN tbInventoryClass on((tbComputerInventory.ClassID = tbInventoryClass.ClassID)))
JOIN tbInventoryProperty on((tbComputerInventory.PropertyID = tbInventoryProperty.PropertyID)))
JOIN tbComputerTarget on((tbComputerInventory.ComputerTargetId = tbComputerTarget.ComputerTargetId)))
ORDER BY tbComputerTarget.Name;
SELECT tbComputerTarget.Name AS `Name`,
tbInventoryProperty.Name AS `PropertyName`,
tbComputerSoftInventory.Value AS `Value`,
tbComputerSoftInventory.InstanceId AS `InstanceId`
FROM ((tbComputerSoftInventory
JOIN tbInventoryProperty on((tbComputerSoftInventory.PropertyID = tbInventoryProperty.PropertyID)))
JOIN tbComputerTarget on((tbComputerSoftInventory.ComputerTargetId = tbComputerTarget.ComputerTargetId)))
ORDER BY tbComputerTarget.Name;
SELECT tbComputerTarget.Name AS `Name`,
tbInventoryProperty.Name AS `PropertyName`,
tbComputerUpdatesInventory.Value AS `Value`,
tbComputerUpdatesInventory.InstanceId AS `InstanceId`
FROM ((tbComputerUpdatesInventory
JOIN tbInventoryProperty on((tbComputerUpdatesInventory.PropertyID = tbInventoryProperty.PropertyID)))
JOIN tbComputerTarget on((tbComputerUpdatesInventory.ComputerTargetId = tbComputerTarget.ComputerTargetId)))
ORDER BY tbComputerTarget.Name;
Текущие запросы (процессы)
SHOW FULL PROCESSLIST;
Замена подстроки
UPDATE items
SET Dimensions = REPLACE(Dimensions, '×', 'x');
