{"text_format":"1","workbook":"xlsx","n_sheets":18,"sheets":["Instructions","Objects","Origination of objects","Move Objects","Objects with requests","Manufacturers","Documents","Log","HD drives","Installations","Overview of licenses and instal","Installation without assigned l","License registry","License history","Installed products","HW detection","SW detection","SW age detection histogram"],"not_rendered":{"charts":18,"images":1,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":19},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":18,"n_cols":1,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Instructions"]
["If you're using the Azure SQL Database, in the “Connection provider” field, select “Microsoft OLE DB Driver for SQL Server (MS Azure)”. In this case, the relevant driver needs to be installed on the computer."]
["Enter the name of the SQL Server, the ALVAO system database name and press the “Set up a connection to the SQL Server” button:"]
[]
["Connection provider:"]
[]
["Server:"]
["localhost"]
["Database name:"]
["alvao"]
["User data shown:"]
[]
[]
[]
[]
["Next time you open a sheet that is already connected to the SQL Server, you can update the data via the Data - Update all command"]
["Note: \n- Pressing the \"Set up a connection to SQL Server\" is followed by showing the currently signed-in user.\n- If you want to delete all data from the workbook, press the \"Delete data\" button.\n- You can delete any sheets in the workbook that you do not use (it accelerates the data update)\n- Any sheets can also be copied (this does not slow down loading)."]
["Notification: \n- Time data is shown in UTC format (time zone +00:00). For example, while using the CET time zone (Central European Time), the time data shown in the workbook is shifted by 1 hour (winter time), respectively by 2 hours (summer time) back with respect to local time.\n- Connection to Azure SQL Database by multi-factor authorization, see https://doc.alvao.com/support/doc/cs/alvao_10_4/troubleshooting/article.aspx?id=108223."]

{"sheet":"Objects","index":1,"n_rows":29,"n_cols":2,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["Objects"]
["This chart shows the number of objects by different kinds of objects. Only objects in the active registry are shown (except for \"Recycle bin\" and \"Disposed assets\")."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Object kind","Count"]

{"sheet":"Origination of objects","index":2,"n_rows":32,"n_cols":2,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Origination of objects"]
["This chart shows the number of created objects in time. Only objects in the active registry are shown (except for \"Recycle bin\" and \"Disposed assets\")."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Object kind","(All)"]
[]
["Created"]

{"sheet":"Move Objects","index":3,"n_rows":33,"n_cols":2,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Move Objects"]
["This chart shows the moves of objects in time. Special objects are not displayed (\"Recycle bin\", \"Object templates\", ...). Child objects are not included in transfers."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Object kind","(All)"]
[]
["Date","Number of moves"]

{"sheet":"Objects with requests","index":4,"n_rows":37,"n_cols":2,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["Objects with requests"]
["The graph depicts objects based on the number of links to requests."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["KPI: Number of linked requests."]
["A large number of linked requests may indicate a problematic device (we recommend filtering the results by the “Incident” process or by a specific targeted Service)."]
[]
["SLA","(All)"]
["Object kind","(All)"]
["Process","(All)"]
["Service","(All)"]
[]
["Object name","Number from Request number"]

{"sheet":"Manufacturers","index":5,"n_rows":33,"n_cols":2,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Manufacturers"]
["This chart shows the number of objects by manufacturers. Special objects are not shown (\"Recycle bin\", \"Object templates\", ...)."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Manufacturer","Součet z Id objektu"]

{"sheet":"Documents","index":6,"n_rows":31,"n_cols":1,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["Documents"]
["This chart shows the number of created documents in time."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Created"]

{"sheet":"Log","index":7,"n_rows":105,"n_cols":6,"rows_kept":105,"cut":false,"hidden":false,"merged":[]}
["Log"]
["The chart shows the number of log records by users. Only records to objects in the active registry are shown (except for \"Recycle bin\" and \"Disposed assets\")."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["User","Number of records"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"etc."]

{"sheet":"HD drives","index":8,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["HD drives"]
["The table shows only logical computer units. If the computer has a drive where the free space is running out (<10%), this condition is indicated in the table."]
["Only computers in the active registry are shown (except for \"Recycle bin\" and \"Disposed assets\")."]
["Object kind","(All)"]
["BitLocker","(All)"]
[]
["Computer"]

{"sheet":"Installations","index":9,"n_rows":31,"n_cols":2,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["Installations"]
["This chart shows the number of detected installations in computers in the active registry (except for \"Recycle bin\" and \"Disposed assets\") in relation to time. The chart does not show freeware products."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Month","Number of installations"]

{"sheet":"Overview of licenses and instal","index":10,"n_rows":36,"n_cols":2,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["Overview of licenses and installations"]
["The chart shows information about the audited software which is not freeware."]
["Legal = the product installation is covered by any kind of license (license, shared license, special installation), or there is a free license, by which this product can be covered."]
["Illegal = the product is not covered by any kind of license."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Product","(All)"]
["Product type","(All)"]
["Cost center","(All)"]
[]
["Legality","Total from Number of installations"]

{"sheet":"Installation without assigned l","index":11,"n_rows":32,"n_cols":2,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Installations without assigned licenses"]
["This chart shows the number of installations in the active registry (except for \"Recycle bin\" and \"Disposed assets\") without an assigned license. The chart does not show freeware products."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Product type","(All)"]
[]
["License status","Number of installations"]

{"sheet":"License registry","index":12,"n_rows":35,"n_cols":2,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["License registry"]
["This chart shows the ratio between the assigned licenses, licenses assigned without reason a free (not assigned) licenses. Only currently valid licenses are shown."]
["The number of free licenses does not include unlimited multilicenses and floating licenses."]
["The number of licenses assigned without reason does not include OEM licenses."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["License status","Total"]

{"sheet":"License history","index":13,"n_rows":32,"n_cols":1,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["License history"]
["This chart shows the number of created licenses in time. Only valid licenses are shown."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Month"]

{"sheet":"Installed products","index":14,"n_rows":36,"n_cols":2,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["Installed products"]
["The chart shows the number of installations of individual products. The chart does not show freeware products."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Software uninstallation detected (UTC)","(All)"]
["Uninstalled","(All)"]
["Operating system","(All)"]
[]
["Product","Number of installations"]

{"sheet":"HW detection","index":15,"n_rows":30,"n_cols":5,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["HW Detection"]
["This chart shows the ratio between various HW detection methods.",null,null,"This chart shows the number of hardware detections performed each month."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Method","Count",null,"Date","Count"]

{"sheet":"SW detection","index":16,"n_rows":30,"n_cols":5,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["SW Detection"]
["This chart shows the ratio between various SW detection methods.",null,null,"This chart shows the number of SW detections performed each month."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Method","Count",null,"Date","Count"]

{"sheet":"SW age detection histogram","index":17,"n_rows":30,"n_cols":2,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["Age detection histogram"]
["This chart shows a SW detection age histogram."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Detection age","Count"]