# TCollection

COLLECTION_QUERY:
select * from TComputer where (COMPUTER_AUDITING & 32) = 32


COLLECTION_QUERY:
select * from TComputer where (COMPUTER_AUDITING & 32) = 0


COLLECTION_QUERY:
select COMPUTER_NAME, PRODUCT_NAME, PRODUCT_VERSION from TComputer inner join TProductInst on PRODUCTINST_COMPUTER_ID = COMPUTER_ID and PRODUCTINST_ADDITION > 1 inner join vProduct on PRODUCTINST_PRODUCT_ID = PRODUCT_ID where PRODUCT_TYPE = 2 and PRODUCT_NAME like 'Windows Server%'


COLLECTION_QUERY:
select COMPUTER_NAME, PRODUCT_NAME, PRODUCT_VERSION from TComputer inner join TProductInst on PRODUCTINST_COMPUTER_ID = COMPUTER_ID and PRODUCTINST_ADDITION > 1 inner join vProduct on PRODUCTINST_PRODUCT_ID = PRODUCT_ID where PRODUCT_TYPE = 2 and PRODUCT_NAME not like 'Windows Server%'


COLLECTION_QUERY:
select COMPUTER_NAME, PRODUCT_NAME, PRODUCT_VERSION from TComputer inner join TProductInst on PRODUCTINST_COMPUTER_ID = COMPUTER_ID and PRODUCTINST_ADDITION > 1 inner join vProduct on PRODUCTINST_PRODUCT_ID = PRODUCT_ID where PRODUCT_TYPE = 2 and PRODUCT_NAME like 'Windows XP%'


COLLECTION_QUERY:
select COMPUTER_NAME, PRODUCT_NAME, PRODUCT_VERSION from TComputer inner join TProductInst on PRODUCTINST_COMPUTER_ID = COMPUTER_ID and PRODUCTINST_ADDITION > 1 inner join vProduct on PRODUCTINST_PRODUCT_ID = PRODUCT_ID where PRODUCT_TYPE = 2 and PRODUCT_NAME like 'Windows Vista%'


COLLECTION_QUERY:
select COMPUTER_NAME, PRODUCT_NAME, PRODUCT_VERSION from TComputer inner join TProductInst on PRODUCTINST_COMPUTER_ID = COMPUTER_ID and PRODUCTINST_ADDITION > 1 inner join vProduct on PRODUCTINST_PRODUCT_ID = PRODUCT_ID where PRODUCT_TYPE = 2 and PRODUCT_NAME like 'Windows 7%'


COLLECTION_QUERY:
select COMPUTER_NAME, PRODUCT_NAME, PRODUCT_VERSION from TComputer inner join TProductInst on PRODUCTINST_COMPUTER_ID = COMPUTER_ID and PRODUCTINST_ADDITION > 1 inner join vProduct on PRODUCTINST_PRODUCT_ID = PRODUCT_ID where PRODUCT_TYPE = 2 and PRODUCT_VERSION not like '%64%'


COLLECTION_QUERY:
select COMPUTER_NAME, PRODUCT_NAME, PRODUCT_VERSION from TComputer inner join TProductInst on PRODUCTINST_COMPUTER_ID = COMPUTER_ID and PRODUCTINST_ADDITION > 1 inner join vProduct on PRODUCTINST_PRODUCT_ID = PRODUCT_ID where PRODUCT_TYPE = 2 and PRODUCT_VERSION like '%64%'


COLLECTION_QUERY:
select COMPUTER_NAME, PRODUCT_NAME, PRODUCT_VERSION from TComputer inner join TProductInst on PRODUCTINST_COMPUTER_ID = COMPUTER_ID and PRODUCTINST_ADDITION > 1 inner join vProduct on PRODUCTINST_PRODUCT_ID = PRODUCT_ID inner join vManufacturer on MANUFACTURER_ID = PRODUCT_MANUFACTURER_ID where PRODUCT_NAME = 'Office' and MANUFACTURER_NAME = 'Microsoft Corporation'


COLLECTION_QUERY:
select COMPUTER_NAME from TComputer inner join TScan on SCAN_COMPUTER_ID = COMPUTER_ID where COMPUTER_ID not in (select COMPUTER_ID from TComputer inner join TProductInst on PRODUCTINST_COMPUTER_ID = COMPUTER_ID and PRODUCTINST_ADDITION > 1 inner join vProduct on PRODUCTINST_PRODUCT_ID = PRODUCT_ID inner join vManufacturer on MANUFACTURER_ID = PRODUCT_MANUFACTURER_ID where PRODUCT_NAME = 'Office' and MANUFACTURER_NAME = 'Microsoft Corporation')


COLLECTION_QUERY:
select * from TComputer where (COMPUTER_TYPE & 16) = 16


COLLECTION_QUERY:
select * from TComputer where (COMPUTER_TYPE & 8) = 8


COLLECTION_QUERY:
select * from TComputer where (COMPUTER_TYPE & 8) = 0


COLLECTION_QUERY:
select COMPUTER_NAME, PRODUCT_NAME, PRODUCT_VERSION from TComputer inner join TProductInst on PRODUCTINST_COMPUTER_ID = COMPUTER_ID and PRODUCTINST_ADDITION > 1 inner join vProduct on PRODUCTINST_PRODUCT_ID = PRODUCT_ID where PRODUCT_TYPE = 2 and PRODUCT_NAME like 'Windows 8%'


COLLECTION_QUERY:
select * from TComputer where COMPUTER_PLATFORM_GROUP = 2


COLLECTION_QUERY:
select * from TComputer where COMPUTER_PLATFORM_GROUP = 11


COLLECTION_QUERY:
select top 5 * from TComputer order by COMPUTER_ID desc


COLLECTION_QUERY:
select * from TComputer where COMPUTER_ID in (select USAGE_COMPUTER_ID from TUsage where (USAGE_TYPE & 256) = 256)


COLLECTION_QUERY:
select * from TMDMDevice where MDMDEVICE_OSTYPE_ID in (select MDMOSTYPE_ID from TMDMOsType where MDMOSTYPE_BIT_ID = 1)


COLLECTION_QUERY:
select * from TMDMDevice where MDMDEVICE_OSTYPE_ID in (select MDMOSTYPE_ID from TMDMOsType where MDMOSTYPE_BIT_ID = 2)


COLLECTION_QUERY:
select * from TMDMDevice where MDMDEVICE_OSTYPE_ID in (select MDMOSTYPE_ID from TMDMOsType where MDMOSTYPE_BIT_ID = 4)


COLLECTION_QUERY:
select * from TMDMDevice where MDMDEVICE_ID in (select MDMDEVICEADDRESS_DEVICE_ID from TMDMDeviceAddress where DATEADD(hour, 24, MDMDEVICEADDRESS_LAST) >= GETDATE())


COLLECTION_QUERY:
select * from TMDMDevice where MDMDEVICE_ID in (select MDMDEVICEADDRESS_DEVICE_ID from TMDMDeviceAddress group by MDMDEVICEADDRESS_DEVICE_ID, MDMDEVICEADDRESS_LAST having DATEADD(day, 7, max(MDMDEVICEADDRESS_LAST)) > GETDATE() and DATEADD(day, 1, max(MDMDEVICEADDRESS_LAST)) < GETDATE())


COLLECTION_QUERY:
select * from TMDMDevice where MDMDEVICE_ID in (select MDMDEVICEADDRESS_DEVICE_ID from TMDMDeviceAddress group by MDMDEVICEADDRESS_DEVICE_ID, MDMDEVICEADDRESS_LAST having DATEADD(day, 7, max(MDMDEVICEADDRESS_LAST)) < GETDATE())


COLLECTION_QUERY:
select * from TMDMDevice where (MDMDEVICE_FLAGS & 1) = 1


COLLECTION_QUERY:
select * from TMDMDevice where (MDMDEVICE_FLAGS & 1) = 0


COLLECTION_QUERY:
select * from TMDMDevice where (MDMDEVICE_FLAGS & 2) = 0


COLLECTION_QUERY:
select * from TMDMDevice where (MDMDEVICE_FLAGS & 2) = 2


COLLECTION_QUERY:
select COMPUTER_NAME, PRODUCT_NAME, PRODUCT_VERSION from TComputer inner join TProductInst on PRODUCTINST_COMPUTER_ID = COMPUTER_ID and PRODUCTINST_ADDITION > 1 inner join vProduct on PRODUCTINST_PRODUCT_ID = PRODUCT_ID where PRODUCT_TYPE = 2 and PRODUCT_NAME like 'Windows 10%'


COLLECTION_QUERY:
select COMPUTER_NAME, PRODUCT_NAME, PRODUCT_VERSION from TComputer inner join TProductInst on PRODUCTINST_COMPUTER_ID = COMPUTER_ID and PRODUCTINST_ADDITION > 1 inner join vProduct on PRODUCTINST_PRODUCT_ID = PRODUCT_ID where PRODUCT_TYPE = 2 and PRODUCT_NAME like 'Windows %'


COLLECTION_QUERY:
select * from TComputer where (COMPUTER_AUDITING & 2) = 2


COLLECTION_QUERY:
select * from TComputer where (COMPUTER_AUDITING & 2) = 0


# TLoggingTrigger

LINE:
Create Trigger tr_%NAME%_log
On dbo.T%NAME%
For Insert, Update, Delete
As

declare @nColumnsUpdated bigint 
set @nColumnsUpdated = convert(bigint, COLUMNS_UPDATED())

declare @IDENTITY_SAVE varchar(50)
set @IDENTITY_SAVE = cast(IsNull(@@IDENTITY, 1) as varchar(50))

declare @nActive int
select @nActive = LOGGINGSETTINGS_NUMBER from TLoggingSettings where LOGGINGSETTINGS_TYPE = 1
if @nActive = 0
  return

declare @nRows int
declare @nActiveInsert int
declare @nActiveUpdate int
declare @nActiveDelete int

declare @nApplicationActive int
declare @nApplicationInsert int
declare @nApplicationUpdate int
declare @nApplicationDelete int

declare @nUserActive int
declare @nUserInsert int
declare @nUserUpdate int
declare @nUserDelete int

declare @nHostnameActive int
declare @nHostnameInsert int
declare @nHostnameUpdate int
declare @nHostnameDelete int

declare @nTableID int
select @nTableID = LOGGINGTABLE_ID, @nActiveInsert = LOGGINGTABLE_INSERT, @nActiveUpdate = LOGGINGTABLE_UPDATE, @nActiveDelete = LOGGINGTABLE_DELETE from TLoggingTable where LOGGINGTABLE_NAME = 'T%NAME%'
if @nTableID is null
begin
  insert into TLoggingTable values('T%NAME%', 1, 1, 1, 1)
  set @nTableID = @@IDENTITY
  set @nActiveInsert = 1
  set @nActiveUpdate = 1
  set @nActiveDelete = 1
end

declare @nUserID int
select @nUserID = LOGGINGUSER_ID, @nUserActive = LOGGINGUSER_ACTIVE, @nUserInsert = LOGGINGUSER_INSERT, @nUserUpdate = LOGGINGUSER_UPDATE, @nUserDelete = LOGGINGUSER_DELETE from TLoggingUser where LOGGINGUSER_NAME = SUSER_SNAME()
if @nUserID is null
begin
  insert into TLoggingUser values(SUSER_SNAME(), 1, 1, 1, 1)
  set @nUserID = @@IDENTITY
  set @nUserActive = 1
  set @nUserInsert = 1
  set @nUserUpdate = 1
  set @nUserDelete = 1
end

if @nUserActive = 0
  goto End2

declare @nHostnameID int
select @nHostnameID = LOGGINGHOSTNAME_ID, @nHostnameActive = LOGGINGHOSTNAME_ACTIVE, @nHostnameInsert = LOGGINGHOSTNAME_INSERT, @nHostnameUpdate = LOGGINGHOSTNAME_UPDATE, @nHostnameDelete = LOGGINGHOSTNAME_DELETE from TLoggingHostname where LOGGINGHOSTNAME_NAME = HOST_NAME()
if @nHostnameID is null
begin
  insert into TLoggingHostname values(HOST_NAME(), 1, 1, 1, 1)
  set @nHostnameID = @@IDENTITY
  set @nHostnameActive = 1
  set @nHostnameInsert = 1
  set @nHostnameUpdate = 1
  set @nHostnameDelete = 1
end

if @nHostnameActive = 0
  goto End2

declare @nApplicationID int
select @nApplicationID = LOGGINGAPPLICATION_ID, @nApplicationActive = LOGGINGAPPLICATION_ACTIVE, @nApplicationInsert = LOGGINGAPPLICATION_INSERT, @nApplicationUpdate = LOGGINGAPPLICATION_UPDATE, @nApplicationDelete = LOGGINGAPPLICATION_DELETE from TLoggingApplication where LOGGINGAPPLICATION_NAME = APP_NAME()
if @nApplicationID is null
begin
  insert into TLoggingApplication values(APP_NAME(), 1, 1, 1, 1)
  set @nApplicationID = @@IDENTITY
  set @nApplicationActive = 1
  set @nApplicationInsert = 1
  set @nApplicationUpdate = 1
  set @nApplicationDelete = 1
end

if @nApplicationActive = 0
  goto End2

if (select count(*) from inserted) > 0 
begin 
  if (select count(*) from deleted) > 0 
  begin 
    -- update 
    select @nActive = LOGGINGACTION_ACTIVE from TLoggingAction where LOGGINGACTION_NAME = 'Update'
    declare @nIgnore int
    select @nIgnore = count(*) from TLoggingColumn where LOGGINGCOLUMN_FLAGS = 1 and LOGGINGCOLUMN_TABLE_ID = @nTableID and LOGGINGCOLUMN_COLUMN = @nColumnsUpdated
    if @nIgnore = 0 and @nActive = 1 and @nActiveUpdate = 1 and @nApplicationUpdate = 1 and @nUserUpdate = 1 and @nHostnameUpdate = 1
    begin
      select @nRows = count(*) from inserted
      insert into TLoggingData select @nTableID, %PRIMARYKEY%, @nRows, @nColumnsUpdated, @nUserID, 2, GETDATE(), @nHostnameID, @nApplicationID, null, 0 from inserted
    end
  end 
  else 
  begin 
    -- insert 
    select @nActive = LOGGINGACTION_ACTIVE from TLoggingAction where LOGGINGACTION_NAME = 'Insert'
    if @nActive = 1 and @nActiveInsert = 1 and @nApplicationInsert = 1 and @nUserInsert = 1  and @nHostnameInsert = 1
    begin
      select @nRows = count(*) from inserted
      insert into TLoggingData select @nTableID, %PRIMARYKEY%, @nRows, 0, @nUserID, 1, GETDATE(), @nHostnameID, @nApplicationID, null, 0 from inserted
    end
  end 
end 
else 
begin 
  -- delete 
  select @nActive = LOGGINGACTION_ACTIVE from TLoggingAction where LOGGINGACTION_NAME = 'Delete'
  if @nActive = 1 and @nActiveDelete = 1 and @nApplicationDelete = 1 and @nUserDelete = 1 and @nHostnameDelete = 1
  begin
    select @nRows = count(*) from deleted
    insert into TLoggingData select @nTableID, %PRIMARYKEY%, @nRows, 0, @nUserID, 3, GETDATE(), @nHostnameID, @nApplicationID, null, 0 from deleted
  end
end 

End2:
declare @maxprec as varchar(2)
set @maxprec=CAST(@@MAX_PRECISION as varchar(2))
exec('select IDENTITY(decimal('+@maxprec+',0),'+@IDENTITY_SAVE+',1) id INTO #tmp')


# TLoggingTriggerOracle

LINE:
CREATE OR REPLACE TRIGGER tr_%NAME%_log
AFTER INSERT OR UPDATE OR DELETE
ON T%NAME% FOR EACH ROW
declare nActive int;
nAI int;
nAU int;
nAD int;
nApA int;
nApI int;
nApU int;
nApD int;
nUA int;
nUI int;
nUU int;
nUD int;
nHA int;
nHI int;
nHU int;
nHD int;
nTID int;
nUID int;
nHID int;
nAID int;
sUser varchar2(256);
sHost varchar2(256);
sApp varchar2(256);
BEGIN
  nActive := 0;
  Begin
  select LOGGINGSETTINGS_NUMBER into nActive from TLoggingSettings where LOGGINGSETTINGS_TYPE = 1;
  EXCEPTION WHEN NO_DATA_FOUND THEN NULL;
  End;
  if nActive = 0 then
    return;
  End If;
  
  Begin
  select LOGGINGTABLE_ID, LOGGINGTABLE_INSERT, LOGGINGTABLE_UPDATE, LOGGINGTABLE_DELETE into nTID, nAI, nAU, nAD from TLoggingTable where UPPER(LOGGINGTABLE_NAME) = 'T%NAME2%';
  EXCEPTION WHEN NO_DATA_FOUND THEN NULL;
  End;
  if nTID is null then
    insert into TLoggingTable values(NULL, 'T%NAME2%', 1, 1, 1, 1);
    select max(LOGGINGTABLE_ID) into nTID from TLoggingTable;
    nAI := 1;
    nAU := 1;
    nAD := 1;
  end if;

  Begin
  SELECT username, machine, program into sUser, sHost, sApp FROM sys.v_$session WHERE audsid = USERENV('SESSIONID') AND audsid != 0 AND rownum = 1;
  EXCEPTION WHEN NO_DATA_FOUND THEN NULL;
  End;

  Begin
  select LOGGINGUSER_ID, LOGGINGUSER_ACTIVE, LOGGINGUSER_INSERT, LOGGINGUSER_UPDATE, LOGGINGUSER_DELETE into nUID, nUA, nUI, nUU, nUD from TLoggingUser where LOGGINGUSER_NAME = sUser;
  EXCEPTION WHEN NO_DATA_FOUND THEN NULL;
  End;
  if nUID is null then
    insert into TLoggingUser values(NULL, sUser, 1, 1, 1, 1);
    select max(LOGGINGUSER_ID) into nUID from TLoggingUser;
    nUA := 1;
    nUI := 1;
    nUU := 1;
    nUD := 1;
  End If;

  if nUA = 0 then
    return;
  End If;

  Begin
  select LOGGINGHOSTNAME_ID, LOGGINGHOSTNAME_ACTIVE, LOGGINGHOSTNAME_INSERT, LOGGINGHOSTNAME_UPDATE, LOGGINGHOSTNAME_DELETE into nHID, nHA, nHI, nHU, nHD from TLoggingHostname where LOGGINGHOSTNAME_NAME = sHost;
  EXCEPTION WHEN NO_DATA_FOUND THEN NULL;
  End;
  if nHID is null then
    insert into TLoggingHostname values(NULL, sHost, 1, 1, 1, 1);
    select max(LOGGINGHOSTNAME_ID) into nHID from TLoggingHostname;
    nHA := 1;
    nHI := 1;
    nHU := 1;
    nHD := 1;
  End If;

  if nHA = 0 then
    return;
  End If;

  Begin
  select LOGGINGAPPLICATION_ID, LOGGINGAPPLICATION_ACTIVE, LOGGINGAPPLICATION_INSERT, LOGGINGAPPLICATION_UPDATE, LOGGINGAPPLICATION_DELETE into nAID, nApA, nApI, nApU, nApD from TLoggingApplication where LOGGINGAPPLICATION_NAME = sApp;
  EXCEPTION WHEN NO_DATA_FOUND THEN NULL;
  End;
  if nAID is null then
    insert into TLoggingApplication values(NULL, sApp, 1, 1, 1, 1);
    select max(LOGGINGAPPLICATION_ID) into nAID from TLoggingApplication;
    nApA := 1;
    nApI := 1;
    nApU := 1;
    nApD := 1;
  End If;

  if nApA = 0 then
    return;
  End If;

IF INSERTING THEN
Begin
  select LOGGINGACTION_ACTIVE into nActive from TLoggingAction where LOGGINGACTION_NAME = 'Insert';
  if nActive = 1 and nAI = 1 and nApI = 1 and nUI = 1 and nHI = 1 then
    insert into TLoggingData values (NULL, nTID, :new.%NAME3%_ID, 1, 0, nUID, 1, SYSDATE, nHID, nAID, NULL, 0);
  End If;
End;
END IF;

IF UPDATING THEN
Begin
  select LOGGINGACTION_ACTIVE into nActive from TLoggingAction where LOGGINGACTION_NAME = 'Update';
  if nActive = 1 and nAU = 1 and nApU = 1 and nUU = 1 and nHU = 1 then
    insert into TLoggingData values (NULL, nTID, :new.%NAME3%_ID, 1, 0, nUID, 2, SYSDATE, nHID, nAID, NULL, 0);
  End If;
End;
END IF;

IF DELETING THEN
Begin
  select LOGGINGACTION_ACTIVE into nActive from TLoggingAction where LOGGINGACTION_NAME = 'Delete';
  if nActive = 1 and nAD = 1 and nApD = 1 and nUD = 1 and nHD = 1 then
    insert into TLoggingData values (NULL, nTID, :old.%NAME3%_ID, 1, 0, nUID, 3, SYSDATE, nHID, nAID, NULL, 0);
  End If;
End;
END IF;

END;


# TMDMCommandList

MDMCOMMANDLIST_DESCRIPTION:
Provede restart zařízení do továrního nastavení a smaže SD kartu.


MDMCOMMANDLIST_DESCRIPTION:
Provede restart zařízení do továrního nastavení.


MDMCOMMANDLIST_DESCRIPTION:
Zakáže použití fotoaparátů zařízení (jen Android 4.0+).


MDMCOMMANDLIST_DESCRIPTION:
Povolí použití fotoaparátů zařízení (jen Android 4.0+).


MDMCOMMANDLIST_DESCRIPTION:
Nastaví čas, než se automaticky zamkne obrazovka při neaktivitě (v milisekundách).


MDMCOMMANDLIST_DESCRIPTION:
Nastaví zadané heslo jako heslo pro odemknutí zařízení.


MDMCOMMANDLIST_DESCRIPTION:
Vyfotí a odešle fotku z předního fotoaparátu zařízení. Pozor, ne všechna zařízení mají přední fotoaparát.


MDMCOMMANDLIST_DESCRIPTION:
Vyfotí a odešle fotku ze zadního fotoaparátu zařízení. Pozor, ne všechna zařízení musejí být vybavena fotoaparátem.


MDMCOMMANDLIST_DESCRIPTION:
Spustí sledování a odesílání GPS souřadnic zařízení. Tato funkce je nutná pro použití GPS tříd.


MDMCOMMANDLIST_DESCRIPTION:
Zakáže sledování a odesílání GPS souřadnic zařízení. Tato funkce je nutná pro použití GPS tříd.


MDMCOMMANDLIST_DESCRIPTION:
Provede inventuru instalovaných balíčků pomocí AuditPro skenu.


MDMCOMMANDLIST_DESCRIPTION:
Nastaví aplikace, jejichž spuštění bude hlášeno. Nevybráním žádné položky se smaže nastavení na zařízení.


MDMCOMMANDLIST_DESCRIPTION:
Povolí a spustí monitoring aplikací službou AuditPro.


MDMCOMMANDLIST_DESCRIPTION:
Zastaví, ale nezakáže, monitoring službou AuditPro.


MDMCOMMANDLIST_DESCRIPTION:
Zakáže a zastaví monitoring službou AuditPro.


MDMCOMMANDLIST_DESCRIPTION:
Přepne stav zařízení 1 = normální, 2 = stav nouze.


MDMCOMMANDLIST_DESCRIPTION:
Přidá záložky do systémového prohlížeče a do prohlížeče Chrome.


MDMCOMMANDLIST_DESCRIPTION:
Odstraní kontatky a záložky, které byly nastavené tímto systémem.


MDMCOMMANDLIST_DESCRIPTION:
Nastaví titulek notifikace, kterou systém hlásí běžící monitoring. Vyžaduje restart monitoringu na zařízení.


MDMCOMMANDLIST_DESCRIPTION:
Nastaví ikonu notifikace, kterou systém hlásí běžící monitoring. Vyžaduje restart monitoringu na zařízení.


MDMCOMMANDLIST_DESCRIPTION:
Nastaví přesměrování hovorů na zadané číslo.


MDMCOMMANDLIST_DESCRIPTION:
Zruší všechna nastavená přesměrování hovorů na zařízení.


MDMCOMMANDLIST_DESCRIPTION:
Nastaví heslo pro zobrazení grafického rozhraní aplikace na zařízení.


MDMCOMMANDLIST_DESCRIPTION:
Smaže jakékoliv nastavené heslo na zařízení


MDMCOMMANDLIST_DESCRIPTION:
Odešle příkaz pro vyvolání odebrání aplikace ze zařízení


MDMCOMMANDLIST_DESCRIPTION:
Odešle na zařízení požadavek na instalaci aplikace z marketu


MDMCOMMANDLIST_DESCRIPTION:
Provede obnovu vybraných dat zpět na zařízení


MDMCOMMANDLIST_DESCRIPTION:
Nastaví network access point. Funguje jen na Android verze 4.1 a nižší.


MDMCOMMANDLIST_NAME:
Nastavit heslo pro přístup do nastavení aplikace

MDMCOMMANDLIST_DESCRIPTION:
Nastaví heslo pro přístup do nastavení aplikace AuditPro MobileDesk client


MDMCOMMANDLIST_DESCRIPTION:
Zakázat použití externích paměťových zařízení


MDMCOMMANDLIST_DESCRIPTION:
Povolit použití externích paměťových zařízení


MDMCOMMANDLIST_DESCRIPTION:
Smaže firemní nastavení a zruší možnost vzdálené správy zařízení.


# TTaskDef

TASKDEF_DESCRIPTION:
Report obsahující informace o všech nově připojených zařízeních (i aktuálně nepřipojených)  tříděno podle uživatelů, + odkaz na registr "hříšníků" s možností evidence prohřešků a jejich četnosti


TASKDEF_DESCRIPTION:
Výpis stavu všech zadaných požadavků. Informace o průměrné délce řešení standardních požadavků.


TASKDEF_NAME:
Přehled umístění médií, dokumentace a nabývacích dokladů

TASKDEF_DESCRIPTION:
Výpis umístění všech instalačních médií, dokumentace a nabývacích dokladů jako podklad pro fyzickou inventuru.


TASKDEF_DESCRIPTION:
Výpis oprávnění ke stanoveným umístěním (adresářům)


TASKDEF_DESCRIPTION:
Přehled vlastněných CALů jako podklad pro zhodnocení jejich dostatečnosti.


TASKDEF_NAME:
Kontrola platnosti školení a certifikací v SAM

TASKDEF_DESCRIPTION:
Školení platné do: zadat datum a ID školení


TASKDEF_NAME:
Kontrola plnění stanovených úkolů, řešení problémů

TASKDEF_DESCRIPTION:
Výpis zadaných úkolů v kalendáři a jejich status


TASKDEF_NAME:
Jaký procentuální podíl pořízených licencí na software je zaznamenáván v inventáři licenčních práv?


TASKDEF_NAME:
Zhodnocení aktuálnosti metod vyhodnocování skutečného využívání licencí softwaru uživateli


TASKDEF_NAME:
Aktualizace platných směrnic a vnitřních norem


TASKDEF_NAME:
Kolik procent počítačů a serverů je aktuálně viditelných a zařazených do inventárního seznamu


TASKDEF_DESCRIPTION:
Má vaše organizace schválený plán vylepšování SAM?
ANO/NE
A) plán vlastního hodnocení a vylepšování SAM byl ve společnosti vytvořen, nedostalo se mu podpory ze strany managementu a nebyl pro něj vyčleněn rozpočet.
B)Byl definován plán vylepšování SAM s jasným rozsahem, časovým plánem a schváleným rozpočtem.
C)Plán vylepšování SAM má definovaný rozsah, časový plán a přidělené prostředky a pokračuje ve vylepšování zahájeném na základě předchozího plánu vylepšování.
D)Jsou implementovány procesy trvalého vylepšování SAM pro podporu flexibilního řízeného prostředí.


TASKDEF_NAME:
Jaký procentuální podíl celkových nákupů softwaru vaší společnosti je prováděn či řízen centralizovaně?


TASKDEF_NAME:
Jaký procentuální podíl softwaru nasazeného do počítačů a serverů ve vaší organizaci (uvážíte-li všechny operační systémy) je instalován prostřednictvím centralizovaných zdrojů či řízeného distribučního prostředí?


TASKDEF_NAME:
Definice zodpovědných osob: Minimum 3 osoby

TASKDEF_DESCRIPTION:
(procurement, operations + osoba za ostatní lokace)


TASKDEF_NAME:
Definice skupin uživatelů s k nim příslušných oprávněných aplikací. Koncepční vs. nekoncepční SW.


TASKDEF_NAME:
Jak často párujete údaje o nasazeném softwaru (používání) s licenčními právy na software (nákupy)?

TASKDEF_DESCRIPTION:
Párování nasazeného a používaného softwaru je prováděno zřídka či nahodile.
Párování nasazeného a používaného softwaru je prováděno ročně.
Párování nasazeného a používaného softwaru je prováděno čtvrtletně.
Párování nasazeného a používaného softwaru je prováděno průběžně.


TASKDEF_NAME:
Jaký procentuální podíl vyřazených aktiv je sledován tak, aby bylo možné znovu používat v něm nainstalovaný software?


TASKDEF_NAME:
Je SAM implementován v celé vaší organizaci a v každé relevantní jednotce?

TASKDEF_DESCRIPTION:
SAM byl implementován pouze v centralizovaných či primárních organizačních jednotkách.
Pro každou organizační jednotku byl určen zástupce s přímou manažerskou zodpovědností za SAM.
Ve všech organizačních jednotkách jsou řízeny procedury a inventarizace SAM.
Všechny organizační jednotky jsou centralizovány a využívají tytéž procedury a postupy inventarizace.


TASKDEF_NAME:
Kompletní soupis zařízení a uživatelů (AD, LDAP)

TASKDEF_DESCRIPTION:
Pro sběr dat při zjišťování majetku musí rozsah údajů dosáhnout alespoň 90% všech zařízení se systémem Microsoft. Jestliže zařízení není připojeno do sítě => ruční sběr


TASKDEF_NAME:
Porovnání soupisů zařízení s minimálně dalším zdrojem dat (Network mangement frameworks, virtuální stroje, HR, anti-virus)


TASKDEF_NAME:
Zahrnutí všech domén a Identifikace aktivních uživatelů


TASKDEF_NAME:
Soupis jakýchkoliv chybějících zařízení (nejsou v síti, zásoby apod.)


TASKDEF_NAME:
Virtuální prostředí, které zahrnuje cluster, licence mobility atd.


TASKDEF_NAME:
Kontrola: upgrady, downgrady, časově omezené licence, aktualizace


TASKDEF_NAME:
Kontrola: serverové licence, klientské přístupové licence (CAL), licencování terminálových služeb, vzdáleného přístupu


TASKDEF_NAME:
Podkladové materiály pro zhodnocení dodavatelů

TASKDEF_DESCRIPTION:
Výpis všech nákupů (licencí, ev. majetku) za poslední zvolené období, tříděné podle dodavatelů, s popisem, množstvím a cenou


TASKDEF_DESCRIPTION:
Výpis všech problémů z helpdesku za dané období tříděné podle dodavatelů


TASKDEF_DESCRIPTION:
Report obsahující souhrn pořizovacích cen SW (ev. jiného majetku) možnost automatického odepisování ceny (různé varianty odpisu) a přehledy zůstatkových cen


TASKDEF_DESCRIPTION:
Aktuální sběr dat a porovnání výsledků s evidencí instalací.


TASKDEF_DESCRIPTION:
Aktuální sběr dat a porovnání výsledků s evidencí licencí.


TASKDEF_DESCRIPTION:
Report obsahující souhrn časově omezených licencí seřazených podle data expirace


TASKDEF_DESCRIPTION:
Report obsahující souhrn SLA seřazených podle data expirace (sledování SLA u licenci a případně i samostatně)


TASKDEF_DESCRIPTION:
Aktuální sběr dat a vyhodnocení, výpis změn oproti předchozímu sběru (možnost výběru) tříděné odle domén, zařízení nebo uživatelů


TASKDEF_DESCRIPTION:
Report obsahující informace o četnosti využití jednotlivých licencí za jednotlivá zařízení tabulka (legenda 1 licence, legenda 2 zařízení, obsah počet využití) + souhrn počtu zařízení skutečně využívajících licenci a rozdíl oproti počtu nakoupených licencí


TASKDEF_DESCRIPTION:
Report obsahující informace o četnosti a intenzitě využití jednotlivých zařízení uživateli tabulka (legenda 1 uživatel, legenda 2 zařízení, obsah počet a intenzita využití)


TASKDEF_DESCRIPTION:
Report obsahující informace o rozdílech mezi nalezeným SW a seznamem koncepčního SW, mezi nalezenou konfiguací HW a HW profilem, tříděno podle uživatelů, + odkaz na registr "hříšníků" s možností evidence prohřešků a jejich četnosti


TASKDEF_NAME:
Identifikace pracovních stanic a serverů v rámci (MSDN®)


TASKDEF_NAME:
U serverů – způsob licencování na CAL nebo procesory


TASKDEF_NAME:
SQL server (verze, edice pro každou SQL server instanci)


TASKDEF_NAME:
Windows server – název serveru, fyzická nebo virtuální data, operační systém – verze, edice, procesor/core


TASKDEF_NAME:
SharePoint Server (MOSS), Project Server (PS) and Team Foundation Server - identifikace všech uživatelů, přístupy za účelem zjištění požadavků CAL, licencování na uživatele/zařízení


TASKDEF_NAME:
System Center - spravované koncové body a typy agentů k určení požadavků na CAL a používané funkce a funkce používané (Standard / Enterprise)


TASKDEF_NAME:
Automatizovaný import licenční situace: Microsoft License Statement (MLS) (dodá MS)


TASKDEF_NAME:
Manuální vložení licencích podkladů: Nabývací doklady a licenční smlouvy a ostatní příslušné dokumenty (OEM, FPP, Service Provider, dokumenty k odprodejím, akvizicím apod.)


TASKDEF_NAME:
Seznam všech poboček, a pokud existují tak všechny podklady k transferu multilicenčních smluv


TASKDEF_NAME:
Informace o spotřebě, nevyužitý nebo nedostatečně využitý SW (výstup z AP)


TASKDEF_NAME:
Doporučení pro optimální licenční model (stávající rizika, závazky, problémy související se současnými postupy, minimalizace rizik v budoucnosti)


# TTranslate

TRANSLATE_VALUE:
Získanie dátumov obstarania a konca záruky


TRANSLATE_VALUE:
Protokollierung der Benutzer nach Häufigkeit


TRANSLATE_VALUE:
Computer mit mehr als 10.000 Datendateien


TRANSLATE_VALUE:
Computer mit installierter Software (Chrome)


TRANSLATE_VALUE:
CPU-Auslastung>25 % in den letzten 90 Tagen


TRANSLATE_VALUE:
Drucken> 100 Seiten in den letzten 30 Tagen


TRANSLATE_VALUE:
Für die letzten 30 Tage nicht überwachte Computer


TRANSLATE_VALUE:
Programme, die für mehr als 30 Tage nicht ausgeführt wurden


TRANSLATE_VALUE:
Benutzer, die für mehr als 30 Tage nicht angemeldet waren


TRANSLATE_VALUE:
Verwenden das Internet länger als eine Stunde pro Tag


TRANSLATE_VALUE:
Laufende, aber nicht installierte Software


TRANSLATE_VALUE:
Installierte, aber nicht verwendete Software


TRANSLATE_VALUE:
Lizenzierte aber nicht installierte Software


TRANSLATE_VALUE:
Inaktive Computer mit zugewiesenen Lizenzen


TRANSLATE_VALUE:
Mangel an Software im Vergleich mit Profilen


TRANSLATE_VALUE:
Gefundene Software verglichen mit SW-Profilen


TRANSLATE_VALUE:
Verbotene Websites während der Arbeitszeit


TRANSLATE_VALUE:
Inaktive Benutzer mit zugewiesenen Lizenzen


TRANSLATE_VALUE:
Neue Produkte in der benutzerspezifischen Produktbibliothek


TRANSLATE_VALUE:
Benutzer mit Cloud an Linzenzen und installierter Software


TRANSLATE_VALUE:
Computers with greatest energy consumption


TRANSLATE_VALUE:
Computers with more than 10 000 data files


TRANSLATE_VALUE:
Computers with installed software (Chrome)


TRANSLATE_VALUE:
Using the Internet for more than an hour a day


TRANSLATE_VALUE:
Inactive computers with licenses assigned


TRANSLATE_VALUE:
The lack of software compared to profiles


TRANSLATE_VALUE:
New products in the custom product library


TRANSLATE_VALUE:
Users with a cloud of licenses and installed software


TRANSLATE_VALUE:
Equipos con más de 10 000 archivos de datos


TRANSLATE_VALUE:
Equipos con el software instalado (Chrome)


TRANSLATE_VALUE:
Uso de la CPU> 25% en los últimos 90 días


TRANSLATE_VALUE:
Impresión> 100 páginas en los últimos 30 días


TRANSLATE_VALUE:
Equipos sin supervisar en los últimos 30 días


TRANSLATE_VALUE:
En ejecución, pero sin software instalado


TRANSLATE_VALUE:
Software con licencia, pero no instalado


TRANSLATE_VALUE:
Equipos inactivos con licencias asignadas


TRANSLATE_VALUE:
La falta de software en comparación con los perfiles


TRANSLATE_VALUE:
Software encontrado contra perfiles de SW


TRANSLATE_VALUE:
Páginas web prohibidas en las horas de trabajo


TRANSLATE_VALUE:
Novedades en la biblioteca de productos personalizados


TRANSLATE_VALUE:
Usuarios con una nube de licencias y software instalado


TRANSLATE_VALUE:
Számítógépek 10 000-nél több adat fájllal


TRANSLATE_VALUE:
Az elmúlt 90 napban a  CPU-t 25%-nál nagyobb mértékben használó gépek


TRANSLATE_VALUE:
Az elmúlt 30 napban 100 oldalnál többet nyomtatók


TRANSLATE_VALUE:
30 napnál régebben be nem jelentkezett felhasználók


TRANSLATE_VALUE:
A szoftverprofilok és a talált szoftverek összevetése


TRANSLATE_VALUE:
Komputery z najwyższym indeksem wydajności


TRANSLATE_VALUE:
Komputery - ponad 10 000 plików medialnych


TRANSLATE_VALUE:
Komputery z zainstalowanym oprogramowaniem (Chrome)


TRANSLATE_VALUE:
Użycie CPU > 25% w ciągu ostatnich 90 dni


TRANSLATE_VALUE:
Wydruki > 100 stron w ciągu ostatnich 30 dni


TRANSLATE_VALUE:
Ponad 30 dni brak logowania użytkowników


TRANSLATE_VALUE:
Użycie Internetu ponad 1 godzinę dziennie


TRANSLATE_VALUE:
Nieaktywne komputery z przypisanymi licencjami


TRANSLATE_VALUE:
Nieaktywni użytkownicy z przypisanymi licencjami


TRANSLATE_VALUE:
Nowy produkt w własnej bibliotece produktów


TRANSLATE_VALUE:
Użytkownicy z cloud licencji i oprogramowania zainstalowanego


TRANSLATE_VALUE:
Компьютеры с более чем 10 000 файлов данных


TRANSLATE_VALUE:
Компьютеры, не подверженные аудиту в течении 90 дней.


TRANSLATE_VALUE:
Использование CPU >25% за последние 90 дней


TRANSLATE_VALUE:
Печать > 100 страниц за последние 30 дней


TRANSLATE_VALUE:
Компьютеры без мониторинга за последние 30 дней


TRANSLATE_VALUE:
Использование интернета более часа в день


TRANSLATE_VALUE:
Лицензированное но не инсталлированное ПО


TRANSLATE_VALUE:
Неактивные компьютеры с назначенными лицензиями


TRANSLATE_VALUE:
Отсутствие программного обеспечения по сравнению с профилями


TRANSLATE_VALUE:
Подключенные USB-устройства за последние 30 дней


TRANSLATE_VALUE:
Запрещенные интернет сайты в рабочие часы


TRANSLATE_VALUE:
Неактивные пользователи с назначенными лицензиями


TRANSLATE_VALUE:
Новые продукты в пользовательской библиотеке


TRANSLATE_VALUE:
Počítače s najväčšou energetickou spotrebou


TRANSLATE_VALUE:
Počítače s viac než 10 000 dátovými súbormi


TRANSLATE_VALUE:
Využitie procesora > 25% za posl. 90 dní


TRANSLATE_VALUE:
Viac ako 30 dní neprihlásenie užívatelia


TRANSLATE_VALUE:
Práca s internetom dlhšie ako hodinu denne za minulý týždeň


TRANSLATE_VALUE:
Neaktívne počítače s priradenými licenciami


TRANSLATE_VALUE:
Neaktívne užívatelia s priradenými licenciami


TRANSLATE_VALUE:
Používatelia s cloud licenciou aj inštalovaným SW


TRANSLATE_VALUE:
Start ringing using device's set ringtone


TRANSLATE_VALUE:
Performs wipe of the device to factory settings, including contents of the SD card


TRANSLATE_VALUE:
Performs wipe of the device to factory settings, leaving contents of the SD card intact


TRANSLATE_VALUE:
Disables cameras on the device (requires Android 4.0+)


TRANSLATE_VALUE:
Enables cameras on the device (requires Android 4.0+)


TRANSLATE_VALUE:
Sets time after which screen lock automatically (in miliseconds)


TRANSLATE_VALUE:
Takes a photo using forward facing camera of the device


TRANSLATE_VALUE:
Takes a photo using backward facing camera of the device


TRANSLATE_VALUE:
Set applications which will be reported when being run on the device.


TRANSLATE_VALUE:
Enables and starts AuditPro monitoring on the device


TRANSLATE_VALUE:
Stops and disables AuditPro monitoring on the device


TRANSLATE_VALUE:
Switch device's state. 1 = normal, 2 = emergency state


TRANSLATE_VALUE:
Adds contacts to the device's contact list


TRANSLATE_VALUE:
Adds bookmarks to device's default browser and Chrome browser


TRANSLATE_VALUE:
Removes contacts and bookmarks added to device by AuditPro MDM


TRANSLATE_VALUE:
Sets title of the notification used to infrom device user about running monitoring


TRANSLATE_VALUE:
Sets text of the notification used to inform device user about running monitoring


TRANSLATE_VALUE:
Sets icon of the notification used to inform device user about running monitoring


TRANSLATE_VALUE:
Sets number where to redirect all calls incoming to the device


TRANSLATE_VALUE:
Disables all call redirection on the device


TRANSLATE_VALUE:
Sets password to access AuditPro agent GUI


TRANSLATE_VALUE:
Uruchom melodię połączenia na urządzeniu


TRANSLATE_VALUE:
Wykonaj kasowanie danych z pamięci telefonu razem z kartą pamięci


TRANSLATE_VALUE:
Wykonaj kasowanie danych z pamięci telefonu, zostawiając dane na karcie pamięci


TRANSLATE_VALUE:
Zablokuj aparat na urządzeniu (wymaga Android 4.0+)


TRANSLATE_VALUE:
Odblokuj aparat na urządzeniu (wymaga Android 4.0+)


TRANSLATE_VALUE:
Określ czas po jakim na urządzeniu zostanie zablokowany ekran (w milisekundach)


TRANSLATE_VALUE:
Wykonaj zdjęcie na urządzeniu używając przedniej kamery


TRANSLATE_VALUE:
Wykonaj zdjęcie na urządzeniu używając tylniej kamery


TRANSLATE_VALUE:
Uruchom śledzenie urządzenia na podstawie GPS


TRANSLATE_VALUE:
Wyłącz śledzenie urządzenia na podstawie GPS


TRANSLATE_VALUE:
Wykonaj skanowanie AuditPro na urządzeniu


TRANSLATE_VALUE:
Ustaw aplikacje, które będą raportowane podczas ich uruchamiania


TRANSLATE_VALUE:
Uruchamia monitoring AuditPro na urządzeniu


TRANSLATE_VALUE:
Zatrzymaj monitoring AuditPro na urządzeniu


TRANSLATE_VALUE:
Zatrzymaj i wyłącz monitoring AuditPro na urządzeniu


TRANSLATE_VALUE:
Zmień stan urządzenia. 1 = stan normalny, 2 = stan wyjątkowy


TRANSLATE_VALUE:
Dodaj kontakt na listę kontaktów w urządzeniu


TRANSLATE_VALUE:
Dodaj zakładkę www do domyślnej przeglądarki internetowej oraz do przeglądarki Chrome


TRANSLATE_VALUE:
Usuwa kontakty i zakładki dodane przez system AuditPro MDM


TRANSLATE_VALUE:
Ustaw tytuł powiadomienia używanego do powiadomienia użytkownika o startcie monitoringu


TRANSLATE_VALUE:
Ustaw tekst powiadomienia używanego do powiadomienia użytkownika o startcie monitoringu


TRANSLATE_VALUE:
Ustaw ikonę powiadomienia używanego do powiadomienia użytkownika o startcie monitoringu


TRANSLATE_VALUE:
Ustaw numer, na który mają być przekierowane wszystkie rozmowy przychodzące


TRANSLATE_VALUE:
Zatrzymuje wszystkie przkierowania na urządzeniu


TRANSLATE_VALUE:
Ustaw hasło do aplikacji Auditpro zainstalowanej na urządzeniu


TRANSLATE_VALUE:
Wykonaj wipe pamięci razem z kartą pamięci


TRANSLATE_VALUE:
Nem haszonszerzésre irányuló tevékenységekre szabadon használható


TRANSLATE_VALUE:
Бесплатное для некоммерческого использования ПО


TRANSLATE_VALUE:
Zestawienie wszystkich zakupów (licencji, zasobów) dokonanych w określonym czasie, sortowane według dostawców, z opisem, ilością i ceną


TRANSLATE_VALUE:
Zestawienie za dany okres wszystkich zgłoszeń kierowanych do  helpdesku, sortowane według dostawców


TRANSLATE_VALUE:
Raport zawierający podsumowanie kosztów SW (zasobów) możliwość dokonania automatycznej amortyzacji (różne warianty amortyzacji) i przegląd wartości księgowych netto


TRANSLATE_VALUE:
Aktualna akwizycja danych i porównanie wyników z ewidencją instalacji


TRANSLATE_VALUE:
Aktualna akwizycja danych i porównanie wyników z ewidencją licencji


TRANSLATE_VALUE:
Raport zawierający podsumowanie ograniczonych czasowo licencji posortowanych wg daty ważności


TRANSLATE_VALUE:
Raport zawierający podsumowanie SLA  posortowanych wg daty ważności (śledzenie SLA w licencjach, w ostateczności oddzielnie)


TRANSLATE_VALUE:
Aktualna akwizycja danych oraz ocena, zestawienie zmian w porównaniu z okresem ubiegłym (możliwość wyboru), sortowane według domen, urządzeń bądź użytkowników


TRANSLATE_VALUE:
Raport zawierający informacje dotyczące częstotliwości wykorzystywania pojedyńczych licencji na pojedyńczych urządzeniach tabela + lista urządzeń wykorzystujących licencje oraz różn


TRANSLATE_VALUE:
Raport zawierający informacje dotyczące częstotliwości oraz natężenia wykorzystywania  poszczególnych urządzeń, tabela (legenda 1 użytkownik, legenda 2 urządzenie, zawartość - liczba i natężenie wykorzystania)


TRANSLATE_VALUE:
Zestawienie stanu wszystkich zgłoszeń. Informacje dotyczące średniego czasu rozwiązywania danego problemu/zgłoszenia.


TRANSLATE_VALUE:
Zestawienie umieszczenia wszystkich medii instalacyjnych i dokumentów zakupu jako podstawa do przeprowadzenia inwentaryzacji.


TRANSLATE_VALUE:
Zestawienie uprawnień dla określonych miejsc (katalogom)


TRANSLATE_VALUE:
Rejestr urządzeń z wykluczeniem SL według użytkownika


TRANSLATE_VALUE:
Rejestr posiadanych CAL'u jako podstawa do wykonania oceny ich przydatności


TRANSLATE_VALUE:
Raport zawierający informacje dotyczące różnic pomiędzy znalezionym SW a zestawieniem sugerowanego SW, pomiędzy odczytaną kofiguracją HW, sortowanie według użytkowników + odwołanie do rejestru 'grzeszników'


TRANSLATE_VALUE:
Raport zawierający informacje dotyczące nowo podłączonych urządzeń  (i tych aktualnie niepodlączonych), sortowanie według użytkowników + odwołanie do rejestru "grzeszników" oraz możliwość ewidencji "grzechów" i ich częstotliwości


TRANSLATE_VALUE:
Ważność szkolenia do: wprowadzić datę oraz ID szkolenia


TRANSLATE_VALUE:
Zestawienie wprowadzonych zadań w kalendarzu oraz ich status.


TRANSLATE_VALUE:
Odbyło się?         TAK/NIE  (TAK załącznik)


TRANSLATE_VALUE:
Czy organizacja ma  zatwierdzony plan poprawy SAM?\nTAK/NiE\nA), plan indywidualnej samooceny i poprawy SAM został w organizacji stworzony, nie otrzymał wsparcia od managementu a nie zostały na ten cel przeznaczone środki. \nB).


TRANSLATE_VALUE:
Porównywanie zainstalowanego i wykorzystywanego software'u jest przeprowadzane rzadko lub przypadkowo.\n Porównywanie zainstalowanego a wykorzystywanego software'u jest przeprowadzane rocznie.\n


TRANSLATE_VALUE:
SAM był realizowany tylko i wyłącznie w centralnych czy też podstawowych jednostkach organizacyjnych.\n Dla każdej jednostki organizacyjnej został określony zastępca/manager  ponoszący pełną odpowiedzialność za SAM.


TRANSLATE_VALUE:
Kontrola: upgrady, downgrady, licencje ograniczone czasowo, aktualizacje


TRANSLATE_VALUE:
Kontrola: licencje serwerowe, licencje dostępu klienta (CAL), licencjonowanie usług terminali, zdalnego dostępu


TRANSLATE_VALUE:
Dokumentacja w celu dokonania oceny dostawców.


TRANSLATE_VALUE:
Aktualne i historycznie zapisane wartości software'u


TRANSLATE_VALUE:
Rejestr lokalizacji medii, dokumentacji oraz dokumentów dokonania zakupu


TRANSLATE_VALUE:
Czy został odpowiednio zdefiniowany ISO SAM manager?


TRANSLATE_VALUE:
Kontrola ważności szkoleń i certyfikacji w SAM


TRANSLATE_VALUE:
Przebiega porównanie wydatków z budżetem


TRANSLATE_VALUE:
Kontrola realizacji określonych zadań, rozwiązywania problemów


TRANSLATE_VALUE:
Jaki procentowy podział nabytych licencji na software jest zapisany w inwentaryzacji praw licencyjnych?


TRANSLATE_VALUE:
Ocena aktualnych metod skutecznego wykorzystywania licencji software'u przez użytkowników


TRANSLATE_VALUE:
Aktualizacja obowiązującyh dyrektyw i norm wewnętrznych


TRANSLATE_VALUE:
Jaki procent komputerów i serwerów jest aktualnie widoczny oraz ujęty w spisie inwentaryzacyjnym?


TRANSLATE_VALUE:
Czy został wytworzony dla określonej daty plan SAM?


TRANSLATE_VALUE:
Jaki procent zakupów software'u dokonanych przez firmę jest prowadzony i zarządzany centralnie?


TRANSLATE_VALUE:
Jaki procent software'u został zainstalowany na komputerach i serwerach w firmie? (Rozważcie wszystkie procesy operacyjne).


TRANSLATE_VALUE:
Jak często są dokonywane porównania zainstalowanego software'u (wykorzystywanego) z prawami licencyjnymi na korzystanie (zakupionego)


TRANSLATE_VALUE:
Jaki procent wykluczonych aktywów jest kontrolowany, w celu wykorzystania zainstalowanego na nich software'u?


TRANSLATE_VALUE:
Czy jest realizowany SAM w całej organizacji  i w każdej odpowiedniej jednostce?


# TLive

LIVE_QUERY:
select coalesce(SUM(LICENSE_PRICE), 0) from TLicense where LICENSE_STATUS = 1 and LICENSE_MODE <> 5


LIVE_QUERY:
select 100 * count(distinct SCAN_COMPUTER_ID) / case when count(distinct COMPUTER_ID) > 0 then count(distinct COMPUTER_ID) else 1 end, count(distinct SCAN_COMPUTER_ID), count(distinct COMPUTER_ID) from TComputer left join TScan on SCAN_COMPUTER_ID = COMPUTER_ID

LIVE_LEVEL2SELECT:
select COMPUTER_NAME from TComputer where COMPUTER_ID in (select SCAN_COMPUTER_ID from TScan)


LIVE_QUERY:
select 100 * count(distinct LICENSE_PRODUCT_ID) / case when count(distinct PRODUCTINST_PRODUCT_ID) > 0 then count(distinct PRODUCTINST_PRODUCT_ID) else 1 end, count(distinct LICENSE_PRODUCT_ID), count(distinct PRODUCTINST_PRODUCT_ID) from TProductInst left join TLicense on LICENSE_PRODUCT_ID = PRODUCTINST_PRODUCT_ID where PRODUCTINST_ADDITION > 1

LIVE_LEVEL2SELECT:
select distinct PRODUCT_NAME + ' ' + PRODUCT_VERSION as PRODUCT1 from TProductInst inner join vProduct on PRODUCT_ID = PRODUCTINST_PRODUCT_ID inner join TLicense on LICENSE_PRODUCT_ID = PRODUCTINST_PRODUCT_ID where PRODUCTINST_ADDITION > 1


LIVE_QUERY:
select 100 * count(distinct c2.COMPUTER_ID) / case when count(distinct c1.COMPUTER_ID) > 0 then count(distinct c1.COMPUTER_ID) else 1 end, count(distinct c2.COMPUTER_ID), count(distinct c1.COMPUTER_ID) from TComputer c1 left join TComputer c2 on c2.COMPUTER_ID = c1.COMPUTER_ID and (c2.COMPUTER_AUDITING & 32) = 32

LIVE_LEVEL2SELECT:
select COMPUTER_NAME from TComputer where (COMPUTER_AUDITING & 32) = 32


LIVE_QUERY:
select coalesce(SUM(INVOICE_PRICE), 0) from TInvoice


LIVE_QUERY:
select 100 * count(distinct PASSPORT_COMPUTER_ID) / case when count(distinct COMPUTER_ID) > 0 then count(distinct COMPUTER_ID) else 1 end, count(distinct PASSPORT_COMPUTER_ID), count(distinct COMPUTER_ID) from TComputer left join TPassport on PASSPORT_COMPUTER_ID = COMPUTER_ID

LIVE_LEVEL2SELECT:
select COMPUTER_NAME from TComputer where COMPUTER_ID in (select distinct PASSPORT_COMPUTER_ID from TPassport)


LIVE_QUERY:
select 100 * count(distinct c2.LICENSE_ID) / case when count(distinct c1.LICENSE_ID) > 0 then count(distinct c1.LICENSE_ID) else 1 end as COUNT1, count(distinct c2.LICENSE_ID), count(distinct c1.LICENSE_ID) from TLicense c1 left join TLicense c2 on c2.LICENSE_ID = c1.LICENSE_ID and (c2.LICENSE_DOCUMENTNUMBER <> '' or c2.LICENSE_INVOICE_ID <> 0)

LIVE_LEVEL2SELECT:
select PRODUCT_NAME + ' ' + PRODUCT_VERSION as PRODUCT1 from TLicense inner join vProduct on PRODUCT_ID = LICENSE_PRODUCT_ID where LICENSE_DOCUMENTNUMBER <> '' or LICENSE_INVOICE_ID <> 0


LIVE_QUERY:
select sum(ATTRIBUTE_NUMBER) as PRICE1 from TAsset inner join TAttribute on ATTRIBUTE_ASSET_ID = ASSET_ID inner join TAttributeType on ATTRIBUTETYPE_ID = ATTRIBUTE_ATTRIBUTETYPE_ID where ATTRIBUTETYPE_NATIVEID = 1 and ATTRIBUTE_NUMBER is not null


LIVE_QUERY:
select cast(AVG(DATEDIFF(mm, ATTRIBUTE_DATE, GETDATE())) / 12.0 as numeric(10,1)) as YEARS1 from TAsset inner join TAttribute on ATTRIBUTE_ASSET_ID = ASSET_ID inner join TAttributeType on ATTRIBUTETYPE_ID = ATTRIBUTE_ATTRIBUTETYPE_ID where ATTRIBUTETYPE_NATIVEID = 6 and ATTRIBUTE_DATE is not null


LIVE_QUERY:
select max(ASSETPROCESS_DATE) from TAssetProcess where ASSETPROCESS_ASSETPROCESSTYPE_ID in (select ASSETPROCESSTYPE_ID from TAssetProcessType where ASSETPROCESSTYPE_NATIVEID = 1000000006)


LIVE_QUERY:
select 100 * count(distinct c2.ASSET_ID) / case when count(distinct c1.ASSET_ID) > 0 then count(distinct c1.ASSET_ID) else 1 end, count(distinct c2.ASSET_ID), count(distinct c1.ASSET_ID) from TAsset c1 left join TAsset c2 on c2.ASSET_ID = c1.ASSET_ID and c2.ASSET_STATUS = 1


LIVE_QUERY:
select 100 * count(distinct c2.ASSET_ID) / case when count(distinct c1.ASSET_ID) > 0 then count(distinct c1.ASSET_ID) else 1 end, count(distinct c2.ASSET_ID), count(distinct c1.ASSET_ID) from TAsset c1 left join TAsset c2 on c2.ASSET_ID = c1.ASSET_ID and c2.ASSET_STATUS = 2


LIVE_QUERY:
select 100 * count(distinct c2.ASSET_ID) / case when count(distinct c1.ASSET_ID) > 0 then count(distinct c1.ASSET_ID) else 1 end, count(distinct c2.ASSET_ID), count(distinct c1.ASSET_ID) from TAsset c1 left join TAsset c2 on c2.ASSET_ID = c1.ASSET_ID and c2.ASSET_STATUS = 4


LIVE_QUERY:
select 100 * count(distinct c2.ASSET_ID) / case when count(distinct c1.ASSET_ID) > 0 then count(distinct c1.ASSET_ID) else 1 end, count(distinct c2.ASSET_ID), count(distinct c1.ASSET_ID) from TAsset c1 left join TAsset c2 on c2.ASSET_ID = c1.ASSET_ID and c2.ASSET_STATUS = 8


LIVE_QUERY:
select 100 * count(distinct USAGE_COMPUTER_ID) / case when count(distinct COMPUTER_ID) > 0 then count(distinct COMPUTER_ID) else 1 end, count(distinct USAGE_COMPUTER_ID), count(distinct COMPUTER_ID) from TComputer left join TUsage on USAGE_COMPUTER_ID = COMPUTER_ID

LIVE_LEVEL2SELECT:
select COMPUTER_NAME from TComputer where COMPUTER_ID in (select distinct USAGE_COMPUTER_ID from TUsage)


LIVE_QUERY:
select top 1 (size * 8) / 1024, (select top 1 (size * 8) / 1024 from sysfiles where [filename] like '%.ldf%') from sysfiles where [filename] like '%.mdf%'


LIVE_QUERY:
select count(distinct loginame) from master.dbo.sysprocesses A, master.dbo.sysdatabases B where A.dbid = B.dbid and B.name = db_name()


LIVE_QUERY:
select max(backup_finish_date) from msdb.dbo.backupmediafamily, msdb.dbo.backupset where msdb.dbo.backupmediafamily.media_set_id = msdb.dbo.backupset.media_set_id and msdb.dbo.backupset.database_name = DB_name()


LIVE_QUERY:
select 100 * count(distinct c2.TASK_ID) / case when count(distinct c1.TASK_ID) > 0 then cast(count(distinct c1.TASK_ID) as float) else 1 end, count(distinct c2.TASK_ID), count(distinct c1.TASK_ID) from TTask c1 left join TTask c2 on c2.TASK_ID = c1.TASK_ID and c2.TASK_STATUS = 1 and c2.TASK_NATIVEID > 2000000 and c2.TASK_NATIVEID < 3000000 where c1.TASK_NATIVEID > 2000000 and c1.TASK_NATIVEID < 3000000


LIVE_QUERY:
select top 1 USER_USERNAME + ' [' + USER_NAME + ' ' + USER_SURNAME + ']' from TUser inner join TTask on TASK_ADMIN_ID = USER_ID where CONVERT(VARCHAR(4), GETDATE(), 111) >= CONVERT(VARCHAR(4), TASK_DATE, 111) order by TASK_DATE asc


LIVE_QUERY:
select min(TASK_DATE) from TTask where TASK_NATIVEID > 2000000 and TASK_NATIVEID < 3000000


LIVE_QUERY:
select min(TASK_DATE) from TTask where TASK_NATIVEID > 2000000 and TASK_NATIVEID < 3000000 and CONVERT(VARCHAR(4), GETDATE(), 111) >= CONVERT(VARCHAR(4), TASK_DATE, 111)


LIVE_QUERY:
select USER_USERNAME, count(*) as COUNT1 from TUserLogin inner join TUser on USER_ID = USERLOGIN_USER_ID group by USER_USERNAME order by COUNT1 desc

LIVE_LEVEL2SELECT:
USER_USERNAME, USERLOGIN_BEGINDATE as DATE1|and USER_USERNAME = '%s'|group by USER_USERNAME, USERLOGIN_BEGINDATE order by USERLOGIN_BEGINDATE


LIVE_QUERY:
select PRODUCT_NAME + ' ' + PRODUCT_VERSION as PRODUCT1, avg(PRODUCTUSAGE_CPU) as AVG1 from TComputer inner join TProductUsage on PRODUCTUSAGE_COMPUTER_ID = COMPUTER_ID inner join TProductUsageFile on PRODUCTUSAGE_PRODUCTUSAGEFILE_ID = PRODUCTUSAGEFILE_ID left join vProduct on PRODUCTUSAGEFILE_PRODUCT_ID = PRODUCT_ID group by PRODUCT_NAME + ' ' + PRODUCT_VERSION order by AVG1 desc, PRODUCT1

LIVE_LEVEL2SELECT:
COMPUTER_NAME, avg(PRODUCTUSAGE_CPU) as AVG1|where PRODUCT_NAME + ' ' + PRODUCT_VERSION = '%s'|group by COMPUTER_NAME


LIVE_QUERY:
select PRODUCT_NAME + ' ' + PRODUCT_VERSION as PRODUCT1, avg(PRODUCTUSAGE_RAM) as AVG1 from TComputer inner join TProductUsage on PRODUCTUSAGE_COMPUTER_ID = COMPUTER_ID inner join TProductUsageFile on PRODUCTUSAGE_PRODUCTUSAGEFILE_ID = PRODUCTUSAGEFILE_ID left join vProduct on PRODUCTUSAGEFILE_PRODUCT_ID = PRODUCT_ID group by PRODUCT_NAME + ' ' + PRODUCT_VERSION order by AVG1 desc, PRODUCT1

LIVE_LEVEL2SELECT:
COMPUTER_NAME, avg(PRODUCTUSAGE_RAM) as AVG1|where PRODUCT_NAME + ' ' + PRODUCT_VERSION = '%s'|group by COMPUTER_NAME


LIVE_QUERY:
select PRODUCT_NAME + ' ' + PRODUCT_VERSION as PRODUCT1, sum(LICENSE_PRICE) as PRICE1, CASE WHEN (select count(*) from TLicense where LICENSE_PRODUCT_ID = PRODUCT_ID and LICENSE_COUNT = -1 and LICENSE_STATUS = 1) > 0 THEN -1 ELSE sum(LICENSE_COUNT) END as COUNT1 from TLicense inner join vProduct on LICENSE_PRODUCT_ID = PRODUCT_ID where LICENSE_STATUS = 1 and LICENSE_PRICE > 0 group by PRODUCT_ID, PRODUCT_NAME + ' ' + PRODUCT_VERSION order by PRICE1 desc


LIVE_QUERY:
select USER_USERNAME, sum(PRODUCTUSAGEF_DURATION) as TIME1 from TProductUsageF inner join TUsage on USAGE_ID = PRODUCTUSAGEF_USAGE_ID inner join TUser on PRODUCTUSAGEF_USER_ID = USER_ID inner join TProductUsageFile on PRODUCTUSAGEFILE_ID = PRODUCTUSAGEF_P_USAGEFILE_ID inner join vProduct on PRODUCT_ID = PRODUCTUSAGEFILE_PRODUCT_ID and PRODUCT_CATEGORY = 4 where PRODUCT_CATEGORY = 4 group by USER_USERNAME order by TIME1 desc

LIVE_LEVEL2SELECT:
PRODUCT_NAME + ' ' + PRODUCT_VERSION as PRODUCT1, sum(PRODUCTUSAGEF_DURATION) as TIME1|and USER_USERNAME = '%s'|group by PRODUCT_NAME + ' ' + PRODUCT_VERSION


LIVE_QUERY:
select USER_USERNAME, sum(USAGETITLE_DURATION) as TIME1 from TUsageTitle inner join TUsage on USAGE_ID = USAGETITLE_USAGE_ID inner join TUser on USAGETITLE_USER_ID = USER_ID inner join TUsageUrl on USAGEURL_ID = USAGETITLE_USAGEURL_ID inner join TUsageProfileContent on USAGEURL_PROFILECONTENT_ID = USAGEPROFILECONTENT_ID inner join TUsageProfile on USAGEPROFILE_ID = USAGEPROFILECONTENT_PROFILE_ID where (USAGEPROFILE_FLAGS & 8) = 8 group by USER_USERNAME order by TIME1 desc

LIVE_LEVEL2SELECT:
USAGETITLE_BEGINDATE as DATE1, USAGETITLE_URL as URL1|and USER_USERNAME = '%s'|group by USER_USERNAME, USAGETITLE_BEGINDATE, USAGETITLE_URL


LIVE_QUERY:
select ASSETTYPE_NAME as TYPE1, cast(AVG(DATEDIFF(mm, ATTRIBUTE_DATE, GETDATE())) / 12.0 as numeric(10,1)) as AGE1, count(*) as COUNT1 from TAsset inner join TAssetType on ASSETTYPE_ID = ASSET_ASSETTYPE_ID inner join TAttribute on ATTRIBUTE_ASSET_ID = ASSET_ID inner join TAttributeType on ATTRIBUTETYPE_ID = ATTRIBUTE_ATTRIBUTETYPE_ID where ATTRIBUTETYPE_NATIVEID = 6 and ATTRIBUTE_DATE is not null and CAST(CONVERT(VARCHAR(4), GETDATE(), 111) as int) - CAST(CONVERT(VARCHAR(4), ATTRIBUTE_DATE, 111) as INT) >= 0 group by ASSETTYPE_NAME, CAST(CONVERT(VARCHAR(4), GETDATE(), 111) as int) - CAST(CONVERT(VARCHAR(4), ATTRIBUTE_DATE, 111) as int)


LIVE_QUERY:
select ASSETTYPE_NAME as TYPE1, coalesce(ATTRIBUTE_STRING, '') as MODEL1, count(*) as COUNT1 from TAssetProcess inner join TAssetProcessType on ASSETPROCESSTYPE_ID = ASSETPROCESS_ASSETPROCESSTYPE_ID inner join TAsset on ASSET_ID = ASSETPROCESS_ASSET_ID inner join TAssetType on ASSETTYPE_ID = ASSET_ASSETTYPE_ID left join TAttribute on ATTRIBUTE_ASSET_ID = ASSET_ID and ATTRIBUTE_ATTRIBUTETYPE_ID in (select ATTRIBUTETYPE_ID from TAttributeType where ATTRIBUTE_ATTRIBUTETYPE_ID = 6) where ASSETPROCESSTYPE_NATIVEID = 1000000003 group by ASSETTYPE_NAME, coalesce(ATTRIBUTE_STRING, '') order by COUNT1 desc


LIVE_QUERY:
select PRODUCT_NAME + ' ' + PRODUCT_VERSION as PRODUCT1, sum(LICENSE_COUNT) as TOTAL1, count(PRODUCTINST_COMPUTER_ID) as COUNT1 from TLicenseShare inner join TComputer on LICENSESHARE_COMPUTER_ID = COMPUTER_ID inner join TLicense on LICENSESHARE_LICENSE_ID = LICENSE_ID and LICENSE_STATUS = 1 inner join vProduct on LICENSE_PRODUCT_ID = PRODUCT_ID left join TProductInst on PRODUCTINST_PRODUCT_ID = PRODUCT_ID and PRODUCTINST_COMPUTER_ID = LICENSESHARE_COMPUTER_ID and PRODUCTINST_ADDITION > 1 group by PRODUCT_NAME + ' ' + PRODUCT_VERSION, PRODUCTINST_COMPUTER_ID order by COUNT1 desc

LIVE_LEVEL2SELECT:
COMPUTER_NAME, count(PRODUCTINST_COMPUTER_ID) as COUNT1|where PRODUCT_NAME + ' ' + PRODUCT_VERSION = '%s'|group by COMPUTER_NAME, PRODUCTINST_COMPUTER_ID


LIVE_NAME:
Počítače s největší energetickou spotřebou

LIVE_QUERY:
select top 20 COMPUTER_NAME, DOMAIN_NAME as DOMAIN1, STR(CEILING(SUM(USAGESTATS_VALUE) / 60 * CASE WHEN (COMPUTER_TYPE & 16) = 16 THEN 0 WHEN (COMPUTER_TYPE & 8) = 8 THEN 75 WHEN (COMPUTER_TYPE & 4) = 4 THEN 300 ELSE 150 END / 1000)) + ' kWh' as CONSUMPTION1 from TUsageStats JOIN TUsage ON USAGE_ID = USAGESTATS_USAGE_ID JOIN TComputer ON USAGE_COMPUTER_ID = COMPUTER_ID JOIN TDomain ON COMPUTER_DOMAIN_ID = DOMAIN_ID WHERE USAGESTATS_TYPE = 9 AND USAGE_BEGINDATE > DATEADD(month, -8, GETDATE()) group by COMPUTER_NAME, DOMAIN_NAME, COMPUTER_TYPE order by SUM(USAGESTATS_VALUE) desc


LIVE_QUERY:
select COMPUTER_NAME, count(*) as COUNT1 from TProductInst inner join TComputer on COMPUTER_ID = PRODUCTINST_COMPUTER_ID and PRODUCTINST_ADDITION > 1 group by COMPUTER_NAME having count(*) > %u order by COUNT1 desc


LIVE_QUERY:
select COMPUTER_NAME, count(*) as COUNT1 from TFileInst inner join TComputer on COMPUTER_ID = FILEINST_COMPUTER_ID and FILEINST_ADDITION > 1 group by COMPUTER_NAME having count(*) > %u order by COUNT1 desc


LIVE_NAME:
Počítače s více než 10 000 datovými soubory

LIVE_QUERY:
select COMPUTER_NAME, count(*) as COUNT1 from TFileInstOther inner join TComputer on COMPUTER_ID = FILEINSTOTHER_COMPUTER_ID and FILEINSTOTHER_ADDITION > 1 group by COMPUTER_NAME having count(*) > %u order by COUNT1 desc


LIVE_QUERY:
select COMPUTER_NAME, min(DOMAIN_NAME) as DOMAIN1 from TComputer left join TDomain on DOMAIN_ID = COMPUTER_DOMAIN_ID where COMPUTER_ID not in (select PASSPORT_COMPUTER_ID from TPassport) group by COMPUTER_NAME order by COMPUTER_NAME


LIVE_QUERY:
select USER_USERNAME from TUser where USER_ID not in (select PASSPORT_USER_ID from TPassport) order by USER_USERNAME


LIVE_QUERY:
select PASSPORT_DATE as DATE1, COMPUTER_NAME, USER_USERNAME from TPassport, TComputer, TUser where COMPUTER_ID = PASSPORT_COMPUTER_ID and USER_ID = PASSPORT_USER_ID and PASSPORT_USER_ACCEPTED = 0


LIVE_QUERY:
select COMPUTER_NAME, PRODUCT_NAME + ' ' + PRODUCT_VERSION as PRODUCT1 from TProductInst, TComputer, vProduct where COMPUTER_ID = PRODUCTINST_COMPUTER_ID and PRODUCTINST_ADDITION > 1 and PRODUCT_ID = PRODUCTINST_PRODUCT_ID and PRODUCT_NAME like '%%%s%%' group by PRODUCT_NAME + ' ' + PRODUCT_VERSION, COMPUTER_NAME order by COMPUTER_NAME


LIVE_QUERY:
select COMPUTER_NAME, SCAN_DATE as DATE1 from TComputer, TScan where DATEADD(day, %u, SCAN_DATE) < GETDATE() and (COMPUTER_AUDITING & 2) = 2 and SCAN_AUDIT_ID in (select AUDIT_ID from TAudit where AUDIT_STATUS = 1) and SCAN_COMPUTER_ID = COMPUTER_ID order by DATE1


LIVE_NAME:
Využití procesoru > 25 % za posl. 90 dní

LIVE_QUERY:
select COMPUTER_NAME, max(USAGESTATS_VALUE) as AVG1 from TUsageStats inner join TUsage on USAGESTATS_USAGE_ID = USAGE_ID and USAGESTATS_TYPE = 1 inner join TComputer on COMPUTER_ID = USAGE_COMPUTER_ID where DATEDIFF(dd, USAGE_BEGINDATE, GETDATE()) < %u group by COMPUTER_NAME having max(USAGESTATS_VALUE) > %u order by AVG1 desc


LIVE_QUERY:
select USER_USERNAME, SUM(PRINTJOB_PAGESPRINTED) as COUNT1 from TPrintJob, TUser where PRINTJOB_USER_ID = USER_ID and DATEDIFF(dd, PRINTJOB_DATE, GETDATE()) < %u group by USER_USERNAME having SUM(PRINTJOB_PAGESPRINTED) > %u order by COUNT1 desc


LIVE_QUERY:
select COMPUTER_NAME from TComputer, TUsage where USAGE_COMPUTER_ID = COMPUTER_ID group by COMPUTER_NAME having DATEADD(day, %u, max(USAGE_BEGINDATE)) < GETDATE()


LIVE_QUERY:
select PRODUCT_NAME + ' ' + PRODUCT_VERSION as PRODUCT1, PRODUCTUSAGEFILE_FILENAME as FILE1, count(*) as COUNT1 from TProductUsage inner join TProductUsageFile on PRODUCTUSAGE_PRODUCTUSAGEFILE_ID = PRODUCTUSAGEFILE_ID left join vProduct on PRODUCTUSAGEFILE_PRODUCT_ID = PRODUCT_ID inner join TComputer on PRODUCTUSAGE_COMPUTER_ID = COMPUTER_ID and PRODUCTUSAGE_FORBIDDEN = 1 where DATEADD(day, %u, PRODUCTUSAGE_BEGINDATE) < GETDATE() group by PRODUCT_NAME + ' ' + PRODUCT_VERSION, PRODUCTUSAGEFILE_FILENAME order by count(*) desc

LIVE_LEVEL2SELECT:
COMPUTER_NAME, PRODUCT_NAME + ' ' + PRODUCT_VERSION as PRODUCT1, FILEHEADER_FILENAME as FILE1, count(*) as COUNT1|and PRODUCT_NAME + ' ' + PRODUCT_VERSION = '%s'|group by COMPUTER_NAME, PRODUCT_NAME + ' ' + PRODUCT_VERSION, FILEHEADER_FILENAME


LIVE_QUERY:
select PRODUCTUSAGEFILE_FILENAME as FILE1, max(PRODUCT_NAME + ' ' + PRODUCT_VERSION) as PRODUCT1, count(*) as COUNT1, max(PRODUCTUSAGE_BEGINDATE) as DATE1 from TProductUsage inner join TProductUsageFile on PRODUCTUSAGEFILE_ID = PRODUCTUSAGE_PRODUCTUSAGEFILE_ID inner join TComputer on PRODUCTUSAGE_COMPUTER_ID = COMPUTER_ID join TUsage on USAGE_COMPUTER_ID = COMPUTER_ID left join vProduct on PRODUCT_ID = PRODUCTUSAGEFILE_PRODUCT_ID where DATEADD(day, %u, PRODUCTUSAGE_BEGINDATE) < GETDATE() group by PRODUCTUSAGEFILE_FILENAME order by COUNT1 desc

LIVE_LEVEL2SELECT:
COMPUTER_NAME, count(*) as COUNT1, max(PRODUCTUSAGE_BEGINDATE) as DATE1|and PRODUCTUSAGEFILE_FILENAME = '%s'|group by COMPUTER_NAME


LIVE_QUERY:
select USER_USERNAME, max(USERLOGIN_BEGINDATE) as DATE1 from TUserLogin inner join TUser on USER_ID = USERLOGIN_USER_ID group by USER_USERNAME having DATEADD(day, %u, max(USERLOGIN_BEGINDATE)) < GETDATE() order by DATE1


LIVE_NAME:
Práce s internetem déle než hodinu denně za minulý týden

LIVE_QUERY:
select COMPUTER_NAME, sum(PRODUCTUSAGEF_DURATION) as TIME1, USAGE_BEGINDATE as SHORTDATE1 from TProductUsageF inner join TUsage on USAGE_ID = PRODUCTUSAGEF_USAGE_ID inner join TComputer on USAGE_COMPUTER_ID = COMPUTER_ID inner join TProductUsageFile on PRODUCTUSAGEFILE_ID = PRODUCTUSAGEF_P_USAGEFILE_ID inner join vProduct on PRODUCT_ID = PRODUCTUSAGEFILE_PRODUCT_ID where DATEDIFF(dd, USAGE_BEGINDATE, GETDATE()) < %u and (PRODUCT_CATEGORY = 6 or PRODUCT_CATEGORY = 14 or PRODUCT_CATEGORY = 23) group by COMPUTER_NAME, USAGE_BEGINDATE having sum(PRODUCTUSAGEF_DURATION) > %u order by TIME1 desc


LIVE_QUERY:
select PRODUCT_NAME + ' ' + PRODUCT_VERSION as PRODUCT1, max(PRODUCTUSAGEFILE_FILENAME) as FILE1, count(*) as COUNT1 from TProductUsage inner join TProductUsageFile on PRODUCTUSAGEFILE_ID = PRODUCTUSAGE_PRODUCTUSAGEFILE_ID inner join TComputer on PRODUCTUSAGE_COMPUTER_ID = COMPUTER_ID inner join vProduct on PRODUCTUSAGEFILE_PRODUCT_ID = PRODUCT_ID left join TProductInst on PRODUCTINST_PRODUCT_ID = PRODUCT_ID and PRODUCTINST_ADDITION > 1 group by PRODUCT_NAME + ' ' + PRODUCT_VERSION, PRODUCTINST_COMPUTER_ID having PRODUCTINST_COMPUTER_ID is null order by COUNT1 desc

LIVE_LEVEL2SELECT:
COMPUTER_NAME, PRODUCTUSAGEFILE_FILENAME as FILE1|where PRODUCT_NAME + ' ' + PRODUCT_VERSION = '%s'|group by COMPUTER_NAME, PRODUCTUSAGEFILE_FILENAME


LIVE_QUERY:
select PRODUCT_NAME + ' ' + PRODUCT_VERSION as PRODUCT1, max(PRODUCTUSAGEFILE_FILENAME) as FILE1, count(*) as COUNT1 from TProductInst inner join TComputer on PRODUCTINST_COMPUTER_ID = COMPUTER_ID inner join vProduct on PRODUCTINST_PRODUCT_ID = PRODUCT_ID left join TProductUsageFile on PRODUCTUSAGEFILE_PRODUCT_ID = PRODUCT_ID left join TProductUsage on PRODUCTUSAGEFILE_ID = PRODUCTUSAGE_PRODUCTUSAGEFILE_ID and PRODUCTUSAGE_COMPUTER_ID = COMPUTER_ID where PRODUCT_TYPE <> 2 and PRODUCTINST_ADDITION > 1 group by PRODUCT_NAME + ' ' + PRODUCT_VERSION, PRODUCTUSAGE_COMPUTER_ID having PRODUCTUSAGE_COMPUTER_ID is null order by COUNT1 desc

LIVE_LEVEL2SELECT:
COMPUTER_NAME, max(PRODUCTUSAGEFILE_FILENAME) as FILE1|and PRODUCT_NAME + ' ' + PRODUCT_VERSION = '%s'|group by COMPUTER_NAME


LIVE_QUERY:
select PRODUCT_NAME + ' ' + PRODUCT_VERSION as PRODUCT1, count(*) as COUNT1 from TLicenseShare inner join TComputer on LICENSESHARE_COMPUTER_ID = COMPUTER_ID inner join TLicense on LICENSESHARE_LICENSE_ID = LICENSE_ID and LICENSE_STATUS = 1 inner join vProduct on LICENSE_PRODUCT_ID = PRODUCT_ID left join TProductInst on PRODUCTINST_PRODUCT_ID = PRODUCT_ID and PRODUCTINST_COMPUTER_ID = LICENSESHARE_COMPUTER_ID and PRODUCTINST_ADDITION > 1 group by PRODUCT_NAME + ' ' + PRODUCT_VERSION, PRODUCTINST_COMPUTER_ID having PRODUCTINST_COMPUTER_ID is null order by COUNT1 desc

LIVE_LEVEL2SELECT:
COMPUTER_NAME|where PRODUCT_NAME + ' ' + PRODUCT_VERSION = '%s'


LIVE_QUERY:
select PRODUCT_NAME + ' ' + PRODUCT_VERSION as PRODUCT1, (sum(LICENSE_COUNT) - (select count(*) from TLicenseShare, TLicense where LICENSE_PRODUCT_ID = PRODUCT_ID and LICENSESHARE_LICENSE_ID = LICENSE_ID and LICENSESHARE_COMPUTER_ID > 0)) as COUNT1 from TLicense left join vProduct on LICENSE_PRODUCT_ID = PRODUCT_ID where LICENSE_STATUS = 1 group by PRODUCT_ID, LICENSE_PRODUCT_ID, PRODUCT_NAME + ' ' + PRODUCT_VERSION having (sum(LICENSE_COUNT) - (select count(*) from TLicenseShare, TLicense where LICENSE_PRODUCT_ID = PRODUCT_ID and LICENSESHARE_LICENSE_ID = LICENSE_ID and LICENSESHARE_COMPUTER_ID > 0)) > 0 order by COUNT1 desc


LIVE_NAME:
Neaktivní počítače s přiřazenými licencemi

LIVE_QUERY:
select PRODUCT_NAME + ' ' + PRODUCT_VERSION as PRODUCT1, count(*) as COUNT1, COMPUTER_NAME from TLicenseShare inner join TComputer on LICENSESHARE_COMPUTER_ID = COMPUTER_ID inner join TLicense on LICENSE_ID = LICENSESHARE_LICENSE_ID inner join vProduct on LICENSE_PRODUCT_ID = PRODUCT_ID where (COMPUTER_AUDITING & 2) = 0 group by PRODUCT_NAME + ' ' + PRODUCT_VERSION, COMPUTER_NAME order by COUNT1 desc

LIVE_LEVEL2SELECT:
COMPUTER_NAME|and PRODUCT_NAME + ' ' + PRODUCT_VERSION = '%s'|group by COMPUTER_NAME


LIVE_QUERY:
select PRODUCT_NAME + ' ' + PRODUCT_VERSION as PRODUCT1, count(*) as COUNT1 from TSwProfileShare inner join TSwProfile on SWPROFILE_ID = SWPROFILESHARE_SWPROFILE_ID inner join TSwProfileContent on SWPROFILECONTENT_SWPROFILE_ID = SWPROFILE_ID inner join vProduct on PRODUCT_ID = SWPROFILECONTENT_PRODUCT_ID inner join TComputer on SWPROFILESHARE_COMPUTER_ID = COMPUTER_ID left join TProductInst on PRODUCTINST_COMPUTER_ID = COMPUTER_ID and PRODUCTINST_PRODUCT_ID = PRODUCT_ID and PRODUCTINST_ADDITION > 1 where (COMPUTER_AUDITING & 2) = 2 group by PRODUCT_NAME + ' ' + PRODUCT_VERSION, PRODUCTINST_PRODUCT_ID having PRODUCTINST_PRODUCT_ID is null

LIVE_LEVEL2SELECT:
COMPUTER_NAME|and PRODUCT_NAME + ' ' + PRODUCT_VERSION = '%s'


LIVE_QUERY:
select PRODUCT_NAME + ' ' + PRODUCT_VERSION as PRODUCT1, count(*) as COUNT1 from TProductInst inner join vProduct on PRODUCT_ID = PRODUCTINST_PRODUCT_ID inner join TComputer on PRODUCTINST_COMPUTER_ID = COMPUTER_ID left join TSwProfileShare on SWPROFILESHARE_COMPUTER_ID = COMPUTER_ID left join TSwProfileContent on SWPROFILECONTENT_PRODUCT_ID = PRODUCT_ID left join TSwProfile on SWPROFILE_ID = SWPROFILESHARE_SWPROFILE_ID and SWPROFILECONTENT_SWPROFILE_ID = SWPROFILE_ID and (SWPROFILE_FLAGS & 2) = 2 where (COMPUTER_AUDITING & 2) = 2 and PRODUCTINST_ADDITION > 1 group by PRODUCT_NAME + ' ' + PRODUCT_VERSION, SWPROFILECONTENT_PRODUCT_ID having SWPROFILECONTENT_PRODUCT_ID is null order by COUNT1 desc


LIVE_QUERY:
select COMPUTER_NAME, count(*) as COUNT1, max(FSOPERATION_DATE) as DATE1 from TComputer inner join TFsOperation on FSOPERATION_COMPUTER_ID = COMPUTER_ID inner join TFileInst on FSOPERATION_FILEINST_ID = FILEINST_ID inner join TFilePath on FILEPATH_ID = FILEINST_FILEPATH_ID inner join TFileHeader on FILEHEADER_ID = FILEINST_FILEHEADER_ID where DATEADD(day, %u, FSOPERATION_DATE) > GETDATE() and len(FILEHEADER_FILENAME) > 0 group by COMPUTER_NAME order by COUNT1 desc

LIVE_LEVEL2SELECT:
COMPUTER_NAME,FSOPERATION_DATE as DATE1,FILEHEADER_FILENAME as FILE1,FILEPATH_PATH as PATH1|and COMPUTER_NAME = '%s' and len(FILEHEADER_FILENAME) > 0|group by COMPUTER_NAME,FSOPERATION_DATE,FILEHEADER_FILENAME,FILEPATH_PATH


LIVE_QUERY:
select USER_USERNAME, sum(USAGETITLE_DURATION) as TIME1 from TUsageTitle inner join TUsage on USAGE_ID = USAGETITLE_USAGE_ID inner join TUser on USAGETITLE_USER_ID = USER_ID inner join TUsageUrl on USAGEURL_ID = USAGETITLE_USAGEURL_ID inner join TUsageProfileContent on USAGEURL_PROFILECONTENT_ID = USAGEPROFILECONTENT_ID inner join TUsageProfile on USAGEPROFILE_ID = USAGEPROFILECONTENT_PROFILE_ID where (USAGEPROFILE_FLAGS & 4) = 4 [WORKINGHOURS] group by USER_USERNAME order by TIME1 desc

LIVE_LEVEL2SELECT:
USER_USERNAME, USAGETITLE_BEGINDATE as DATE1, USAGETITLE_URL as URL1|and USER_USERNAME = '%s' [WORKINGHOURS]|group by USER_USERNAME, USAGETITLE_BEGINDATE, USAGETITLE_URL


LIVE_QUERY:
select 100 * count(distinct c2.LICENSE_ID) / case when count(distinct c1.LICENSE_ID) > 0 then count(distinct c1.LICENSE_ID) else 1 end as COUNT1 from TLicense c1 left join TLicense c2 on c2.LICENSE_ID = c1.LICENSE_ID and c2.LICENSE_DOCUMENTNUMBER <> ''


LIVE_NAME:
Neaktivní uživatelé s přiřazenými licencemi

LIVE_QUERY:
select PRODUCT_NAME + ' ' + PRODUCT_VERSION as PRODUCT1, count(*) as COUNT1, USER_USERNAME from TLicenseShare inner join TUser on LICENSESHARE_USER_ID = USER_ID inner join TLicense on LICENSE_ID = LICENSESHARE_LICENSE_ID inner join vProduct on LICENSE_PRODUCT_ID = PRODUCT_ID where (USER_STATUS & 1) = 0 group by PRODUCT_NAME + ' ' + PRODUCT_VERSION, USER_USERNAME order by COUNT1 desc

LIVE_LEVEL2SELECT:
USER_USERNAME|and PRODUCT_NAME + ' ' + PRODUCT_VERSION = '%s'|group by USER_USERNAME


LIVE_QUERY:
select COMPUTER_NAME, min(DOMAIN_NAME) as DOMAIN1, min(LOGGINGDATA_DATE) as DATE1 from TLoggingData inner join TLoggingTable on LOGGINGTABLE_ID = LOGGINGDATA_TABLE_ID and upper(LOGGINGTABLE_NAME) = 'TCOMPUTER' inner join TComputer on COMPUTER_ID = LOGGINGDATA_ENTITY_ID left join TDomain on DOMAIN_ID = COMPUTER_DOMAIN_ID where (LOGGINGDATA_ACTION = 1) group by COMPUTER_NAME order by COMPUTER_NAME


LIVE_QUERY:
select USER_USERNAME, LOGGINGDATA_DATE as DATE1 from TLoggingData inner join TLoggingTable on LOGGINGTABLE_ID = LOGGINGDATA_TABLE_ID and upper(LOGGINGTABLE_NAME) = 'TUSER' inner join TUser on USER_ID = LOGGINGDATA_ENTITY_ID left join TGroup on GROUP_ID = USER_GROUP_ID where (LOGGINGDATA_ACTION = 1 or LOGGINGDATA_ACTION = 3) order by USER_USERNAME


LIVE_QUERY:
select COMPUTER_NAME, count(*) as COUNT1, max(LOGGINGDATA_DATE) as DATE1 from TLoggingData inner join TLoggingTable on LOGGINGTABLE_ID = LOGGINGDATA_TABLE_ID and upper(LOGGINGTABLE_NAME) = 'TDEVICE' inner join TDevice on DEVICE_ID = LOGGINGDATA_ENTITY_ID inner join TDeviceType on DEVICETYPE_ID = DEVICE_TYPE inner join TComputer on COMPUTER_ID = DEVICE_COMPUTER_ID where (LOGGINGDATA_ACTION = 1 or LOGGINGDATA_ACTION = 3) group by COMPUTER_NAME order by COUNT1 desc

LIVE_LEVEL2SELECT:
COMPUTER_NAME, DEVICETYPE_NAME + '/' + DEVICE_MODEL as DEVICE1, LOGGINGDATA_DATE as DATE1|and COMPUTER_NAME = '%s'|group by COMPUTER_NAME, DEVICETYPE_NAME + '/' + DEVICE_MODEL, LOGGINGDATA_DATE order by COMPUTER_NAME


LIVE_QUERY:
select PRODUCT_NAME + ' ' + PRODUCT_VERSION as PRODUCT1, count(*) as COUNT1 from TLoggingData inner join TLoggingTable on LOGGINGTABLE_ID = LOGGINGDATA_TABLE_ID and upper(LOGGINGTABLE_NAME) = 'TUSERPRODUCT' inner join TUserProduct on PRODUCT_ID = LOGGINGDATA_ENTITY_ID inner join vManufacturer on MANUFACTURER_ID = PRODUCT_MANUFACTURER_ID where (LOGGINGDATA_ACTION = 1 or LOGGINGDATA_ACTION = 3) group by PRODUCT_NAME + ' ' + PRODUCT_VERSION order by PRODUCT1


LIVE_QUERY:
select PRODUCT_NAME + ' ' + PRODUCT_VERSION as PRODUCT1, sum(LICENSE_COUNT) as COUNT1 from TLoggingData inner join TLoggingTable on LOGGINGTABLE_ID = LOGGINGDATA_TABLE_ID and upper(LOGGINGTABLE_NAME) = 'TLICENSE' inner join TLicense on LICENSE_ID = LOGGINGDATA_ENTITY_ID inner join vProduct on PRODUCT_ID = LICENSE_PRODUCT_ID inner join vManufacturer on MANUFACTURER_ID = PRODUCT_MANUFACTURER_ID where (LOGGINGDATA_ACTION = 1 or LOGGINGDATA_ACTION = 3) group by PRODUCT_NAME + ' ' + PRODUCT_VERSION order by PRODUCT1


LIVE_QUERY:
select COMPUTER_NAME, max(USER_USERNAME) as USER_USERNAME, count(*) as COUNT1 from TLoggingData inner join TLoggingTable on LOGGINGTABLE_ID = LOGGINGDATA_TABLE_ID and upper(LOGGINGTABLE_NAME) = 'TPASSPORT' inner join TPassport on PASSPORT_ID = LOGGINGDATA_ENTITY_ID inner join TComputer on PASSPORT_COMPUTER_ID = COMPUTER_ID left join TUser on PASSPORT_USER_ID = USER_ID where (LOGGINGDATA_ACTION = 1 or LOGGINGDATA_ACTION = 3) group by COMPUTER_NAME, PASSPORT_ID order by COMPUTER_NAME, USER_USERNAME


LIVE_QUERY:
select PRODUCT_NAME + ' ' + PRODUCT_VERSION as PRODUCT1, count(*) as COUNT1 from TLoggingData inner join TLoggingTable on LOGGINGTABLE_ID = LOGGINGDATA_TABLE_ID and upper(LOGGINGTABLE_NAME) = 'TPRODUCTINST' left join TProductInst on PRODUCTINST_ID = LOGGINGDATA_ENTITY_ID inner join vProduct on PRODUCT_ID = PRODUCTINST_PRODUCT_ID inner join vManufacturer on MANUFACTURER_ID = PRODUCT_MANUFACTURER_ID left join TFileInst on FILEINST_ID = PRODUCTINST_FILEINST_ID left join TFilePath on FILEPATH_ID = FILEINST_FILEPATH_ID left join TFileHeader on FILEHEADER_ID = FILEINST_FILEHEADER_ID inner join TComputer on COMPUTER_ID = PRODUCTINST_COMPUTER_ID where LOGGINGDATA_ACTION = 1 group by PRODUCT_NAME + ' ' + PRODUCT_VERSION order by COUNT1 desc

LIVE_LEVEL2SELECT:
COMPUTER_NAME, FILEPATH_PATH as PATH1, FILEHEADER_FILENAME as FILE1|and PRODUCT_NAME + ' ' + PRODUCT_VERSION = '%s'|group by COMPUTER_NAME, FILEPATH_PATH, FILEHEADER_FILENAME


LIVE_QUERY:
select 100 * count(distinct c2.COMPUTER_ID) / case when count(distinct c1.COMPUTER_ID) > 0 then count(distinct c1.COMPUTER_ID) else 1 end, count(distinct c2.COMPUTER_ID), count(distinct c1.COMPUTER_ID) from TComputer c1 left join TComputer c2 on c2.COMPUTER_ID = c1.COMPUTER_ID and (c2.COMPUTER_AUDITING & 2) = 0

LIVE_LEVEL2SELECT:
select COMPUTER_NAME from TComputer where (COMPUTER_AUDITING & 2) = 0


LIVE_QUERY:
select 100 * count(distinct c2.COMPUTER_ID) / case when count(distinct c1.COMPUTER_ID) > 0 then count(distinct c1.COMPUTER_ID) else 1 end, count(distinct c2.COMPUTER_ID), count(distinct c1.COMPUTER_ID) from TComputer c1 left join TComputer c2 on c2.COMPUTER_ID = c1.COMPUTER_ID and c1.COMPUTER_ID not in (select COMPUTERSHARE_COMPUTER_ID from TComputerShare)

LIVE_LEVEL2SELECT:
select COMPUTER_NAME from TComputer where COMPUTER_ID not in (select distinct COMPUTERSHARE_COMPUTER_ID from TComputerShare)


LIVE_QUERY:
select PRODUCT_NAME + ' ' + PRODUCT_VERSION as PRODUCT1,
COALESCE(ROUND((select sum(LICENSE_PRICE) / sum(LICENSE_COUNT) * (sum(LICENSE_COUNT) - count(distinct PRODUCTUSAGE_COMPUTER_ID)) from TLicense where LICENSE_PRODUCT_ID = PRODUCT_ID and LICENSE_COUNT > 0 and LICENSE_STATUS = 1), 0), 0) as PRICE1
from TProductUsage
inner join TProductUsageFile on PRODUCTUSAGEFILE_ID = PRODUCTUSAGE_PRODUCTUSAGEFILE_ID 
join TUsage on USAGE_COMPUTER_ID = PRODUCTUSAGE_COMPUTER_ID 
inner join vProduct on PRODUCT_ID = PRODUCTUSAGEFILE_PRODUCT_ID 
where DATEADD(day, 90, PRODUCTUSAGE_BEGINDATE) > GETDATE()
group by PRODUCT_NAME + ' ' + PRODUCT_VERSION, PRODUCT_ID
having COALESCE(ROUND((select sum(LICENSE_PRICE) / sum(LICENSE_COUNT) * (sum(LICENSE_COUNT) - count(distinct PRODUCTUSAGE_COMPUTER_ID)) from TLicense where LICENSE_PRODUCT_ID = PRODUCT_ID and LICENSE_COUNT > 0 and LICENSE_STATUS = 1), 0), 0) <> 0
order by PRICE1 desc


LIVE_QUERY:
select USER_USERNAME, sum(USAGETITLE_DURATION) as TIME1 from TUsageTitle inner join TUsage on USAGE_ID = USAGETITLE_USAGE_ID inner join TUser on USAGETITLE_USER_ID = USER_ID inner join TUsageUrl on USAGEURL_ID = USAGETITLE_USAGEURL_ID inner join TUsageProfileContent on USAGEURL_PROFILECONTENT_ID = USAGEPROFILECONTENT_ID inner join TUsageProfile on USAGEPROFILE_ID = USAGEPROFILECONTENT_PROFILE_ID where (USAGEPROFILE_FLAGS & 16) = 16 group by USER_USERNAME order by TIME1 desc


LIVE_QUERY:
select coalesce(SUM(l1.LICENSE_COST), 0) + coalesce(SUM(l2.LICENSE_COST/12), 0) from TLicense l1
left join TLicense l2 on l2.LICENSE_STATUS = 1 and l2.LICENSE_MODE = 5 and l2.LICENSE_COST_PERIOD = 1
where l1.LICENSE_STATUS = 1 and l1.LICENSE_MODE = 5 and l1.LICENSE_COST_PERIOD = 0


LIVE_QUERY:
select sum(CONTRACT_COST1+CONTRACT_COST2) from TContract where CONTRACT_STATUS = 1


LIVE_QUERY:
select cast(sum(LICENSE_PRICE)/count(distinct COMPUTER_ID)/count(distinct COMPUTER_ID) AS INTEGER) FROM TLicense
LEFT JOIN TComputer ON 1=1


LIVE_NAME:
Uživatelé s cloud licencí i instalovaným SW

LIVE_QUERY:
select USER_USERNAME, USER_NUMBER from TUser
inner join TComputerShare on COMPUTERSHARE_USER_ID = USER_ID
inner join TComputer on COMPUTER_ID = COMPUTERSHARE_COMPUTER_ID
inner join TLicenseShare on LICENSESHARE_COMPUTER_ID = COMPUTER_ID or LICENSESHARE_USER_ID = USER_ID
inner join TLicense on LICENSESHARE_LICENSE_ID = LICENSE_ID and LICENSE_MODE = 5
where COMPUTER_ID in (select PRODUCTINST_COMPUTER_ID from TProductInst where PRODUCTINST_ADDITION > 1)


LIVE_QUERY:
select COMPUTER_NAME as NAME1, cast(sum(LICENSE_PRICE)/sum(LICENSE_COUNT) as numeric(18,2)) as PRICE1 from TComputer left join TLicenseShare on COMPUTER_ID = LICENSESHARE_COMPUTER_ID left join TLicense on LICENSESHARE_LICENSE_ID = LICENSE_ID where LICENSE_COUNT > 0 group by COMPUTER_ID, COMPUTER_NAME, COMPUTER_PRODUCTNUMBER, COMPUTER_NUMBER order by PRICE1 desc


LIVE_QUERY:
select COMPUTER_NAME as NAME1, cast(coalesce(COMPUTER_PRICE,0)+sum(coalesce(HWPROFILE_PRICE,0)) as numeric(18,2)) as PRICE1
from TComputer
left join THwProfileShare on COMPUTER_ID = HWPROFILESHARE_COMPUTER_ID
left join THwProfile on HWPROFILESHARE_HWPROFILE_ID = HWPROFILE_ID
group by COMPUTER_ID, COMPUTER_NAME, COMPUTER_PRODUCTNUMBER, COMPUTER_NUMBER, COMPUTER_PRICE
order by PRICE1 desc


LIVE_QUERY:
select sum(PRICE1) from (
select COMPUTER_NAME as NAME1, cast(coalesce(COMPUTER_PRICE,0)+sum(coalesce(HWPROFILE_PRICE,0)) as numeric(18,2)) as PRICE1
from TComputer
left join THwProfileShare on COMPUTER_ID = HWPROFILESHARE_COMPUTER_ID
left join THwProfile on HWPROFILESHARE_HWPROFILE_ID = HWPROFILE_ID
group by COMPUTER_ID, COMPUTER_NAME, COMPUTER_PRODUCTNUMBER, COMPUTER_NUMBER,COMPUTER_PRICE
) tmp


LIVE_QUERY:
select sum(PRICE1) from (
select PRODUCT_NAME + ' ' + PRODUCT_VERSION as PRODUCT1, count(*) as COUNT1, SUM(LICENSE_PRICE)/(case when SUM(LICENSE_COUNT) = 0 then 1 else SUM(LICENSE_COUNT) end) as PRICE1 from TLicenseShare 
inner join TComputer on LICENSESHARE_COMPUTER_ID = COMPUTER_ID 
inner join TLicense on LICENSESHARE_LICENSE_ID = LICENSE_ID and LICENSE_STATUS = 1 and LICENSE_MODE <> 5
inner join vProduct on LICENSE_PRODUCT_ID = PRODUCT_ID and PRODUCT_TYPE <> 2
left join TProductUsageFile on PRODUCTUSAGEFILE_PRODUCT_ID = PRODUCT_ID 
left join TProductUsage on PRODUCTUSAGEFILE_ID = PRODUCTUSAGE_PRODUCTUSAGEFILE_ID and PRODUCTUSAGE_COMPUTER_ID = COMPUTER_ID
group by COMPUTER_ID, PRODUCT_NAME + ' ' + PRODUCT_VERSION, PRODUCTUSAGE_COMPUTER_ID 
having PRODUCTUSAGE_COMPUTER_ID is null
) tmp


LIVE_QUERY:
select COMPUTER_NAME, cast(sum(LICENSE_PRICE)/sum(LICENSE_COUNT) as numeric(18,2)) as PRICE1 from TLicenseShare inner join TComputer on LICENSESHARE_COMPUTER_ID = COMPUTER_ID inner join TLicense on LICENSESHARE_LICENSE_ID = LICENSE_ID and LICENSE_STATUS = 1 and LICENSE_MODE <> 5 inner join vProduct on LICENSE_PRODUCT_ID = PRODUCT_ID and PRODUCT_TYPE <> 2 left join TFileHeader on FILEHEADER_PRODUCT_ID = PRODUCT_ID left join TProductUsage on FILEHEADER_ID = PRODUCTUSAGE_FILEHEADER_ID and PRODUCTUSAGE_COMPUTER_ID = COMPUTER_ID where LICENSE_COUNT > 0 group by COMPUTER_NAME, PRODUCTUSAGE_COMPUTER_ID having PRODUCTUSAGE_COMPUTER_ID is null order by PRICE1 desc


LIVE_QUERY:
select COMPUTER_NAME, PRODUCT_NAME + ' ' + PRODUCT_VERSION as PRODUCT1, FILEHEADER_FILENAME as FILE1, count(*) as COUNT1 from TProductUsage inner join TFileHeader on PRODUCTUSAGE_FILEHEADER_ID = FILEHEADER_ID left join vProduct on FILEHEADER_PRODUCT_ID = PRODUCT_ID inner join TComputer on PRODUCTUSAGE_COMPUTER_ID = COMPUTER_ID where PRODUCTUSAGE_FORBIDDEN = 1 and CONVERT(VARCHAR(10), GETDATE(), 111) = CONVERT(VARCHAR(10), PRODUCTUSAGE_BEGINDATE, 111) group by COMPUTER_NAME, PRODUCT_NAME + ' ' + PRODUCT_VERSION, FILEHEADER_FILENAME


LIVE_QUERY:
select PRODUCT_NAME + ' ' + PRODUCT_VERSION as PRODUCT1, COMPUTER_NAME, MAX(PRODUCTUSAGE_BEGINDATE) as DATE1 from TProductUsage inner join TFileHeader on FILEHEADER_ID = PRODUCTUSAGE_FILEHEADER_ID inner join vProduct on PRODUCT_ID = FILEHEADER_PRODUCT_ID inner join TComputer on COMPUTER_ID = PRODUCTUSAGE_COMPUTER_ID where PRODUCT_CATEGORY = 4 and CONVERT(VARCHAR(10), GETDATE(), 111) = CONVERT(VARCHAR(10), PRODUCTUSAGE_BEGINDATE, 111) group by PRODUCT_NAME + ' ' + PRODUCT_VERSION, COMPUTER_NAME


LIVE_QUERY:
select USAGETITLE_URL, COMPUTER_NAME, max(USAGETITLE_BEGINDATE) as DATE1 from TUsageProfile inner join TUsageProfileContent on USAGEPROFILECONTENT_PROFILE_ID = USAGEPROFILE_ID inner join TUsageUrl on USAGEURL_PROFILECONTENT_ID = USAGEPROFILECONTENT_ID inner join TUsageTitle on USAGETITLE_USAGEURL_ID = USAGEURL_ID inner join TUsage on USAGETITLE_USAGE_ID = USAGE_ID inner join TComputer on COMPUTER_ID = USAGE_COMPUTER_ID where (USAGEPROFILE_FLAGS & 4) = 4 and CONVERT(VARCHAR(10), GETDATE(), 111) = CONVERT(VARCHAR(10), USAGETITLE_BEGINDATE, 111) group by USAGETITLE_URL, COMPUTER_NAME


