Spider 6.4.8-R1 update is available Release Date: 2023-02-03 A new update has been released for Spider. Please see the included changes below. To be notified of these kinds of product updates, please ensure that you have subscribed to the Spider Release blog. Corrections in Spider 6.4.8-R1 The February 2023 update of Spider contains the following corrections. Feature Description User interface The employee view search page has been extended to support legal entity permission by default. If the filters were discarded in the graphical representation of a search result, the view did not reset itself. Under certain circumstances, an error could occur in the manufacturer search if a global manufacturer filter was selected. An internally used column was displayed on the legal entity view in the compliance for products. Under certain circumstances, placeholder text was displayed on the assignment page for SAM priorities. Search In searches that use a GUID as main object identifier, the search result was not displayed. Setup Installation checks for the ESI have been removed from the setup as they are no longer needed. In certain cases, an error could occur when creating the base views during a spider update. ... View more

The January 2023 update of the Spider Software Services is available. All components are available in our Product and License Center. Highlights Visual Studio Community (Device) is now available as Visual Studio Community Free (Device) and Visual Studio Community (Device, Win), which is marked as license relevant. Additional License Metrics Procedures for Microsoft Office 365 Enterprise E1 added. All ASG Technologies Products/Versions moved to manufacturer Rocket Software, Inc. Corel Academic Site License Agreements extended with 1- and 3-years duration of Level 2 contracts. ACD Systems International Inc. products ACDSee Photo Editor renamed to ACDSee Gemstone Photo Editor. Recognition Catalog The Recognition Catalog contains normalization and recognition capabilities for more than 2.911.656 inventoried programs, 133.457 software publisher, and 7.005.170 inventoried files. For more details, please check the Recognition Change Notes document. Software and SKU Catalog The Software Catalog contains more than 1.172.814 relevant and normalized articles (SKUs) of software licenses and maintenances and more than 70.394 license relevant product versions.  Summary of the supplemented catalog items: Articles (SKUs): 6.151 Versions: 95 ... View more

The December 2022 update of the Spider Software Services version 1.2212.1.2062 is now available. All components are available in our Product and License Center. Highlights New version 2022 of Microsoft SQL Server and SCCM added incl LMPs New licensing of Microsoft Windows Server for Virtual Machines implemented Improved classification for Adobe Single App and China region products Improved classification for Microsoft Power BI Report Server Added License Metrics Procedures for Microsoft Office 365 Enterprise E1 Recognition Catalog The  Recognition Catalog contains normalization and recognition capabilities for more than 2.907.886 inventoried programs 132.374 software publisher 6.985.288 inventoried files For more details, please check the Recognition change notes document. Software and SKU Catalog The Software Catalog contains more than  1.166.663 relevant and normalized articles (SKUs)  of software licenses and maintenances and more than 70.299 license-relevant product versions. Summary of the supplemented catalog items: Articles (SKUs): 1.450 Versions: 74 Spider Data Collector The  Spider Data Collector (SDC) provides a set of connectors to 3rd party inventory for an out-of-the-box collection of computers, software, users, virtualization, and many more. Please check the Spider Data Collector User Manual for a full reference of all connectors. ... View more

Spider 6.4.8 update is available Release Date: 2022-12-15 A new update has been released for Spider. Please see the included changes below. To be notified of these kinds of product updates, please ensure that you have subscribed to the Spider Release blog. New Features and Improvements to Spider in Dec 2022 Spider 6.4.8 includes the following product features and improvements. Feature Description Index-based search The new index-based search in Spider enables users to find objects across the entire application suite. The search is integrated on almost all pages on the top right of the navigation bar. Permissions of legal entities are fully respected in the index-based search. Various ways of filtering the search result are supported. To protect disk space, the feature is delivered disabled. For more information around the index-based search, visit the Flexera Community at: https://community.flexera.com/t5/Spider-Knowledge-Base/Index-based-search/ta-p/257931 Usability for selecting defaults The page for selecting software products (select standard) has been revised for improved usability. Now the page accepts multiple search filters and grouping of the search result has been enabled. Employee The employee search in the master data now also resolves connected users. If an employee is stored for several users, the employee will be displayed several times. The User Mapped field supports filtering. License allocations Previously it was possible to maintain multiple license allocations for a single legal entity under one license. This is now prevented. Existing allocations will be migrated to the latest license allocation. Furthermore, the bulk import for license allocations has been integrated. Accessibility Keyboard navigations in table views has been revised. Paging and sorting using the keyboard have been improved.   Corrections in Spider 6.4.8 The December 2022 update of Spider contains the following corrections. Feature Description User interface If a specially filtered and grouped search result was opened and the search page was immediately reloaded, an error could occur. Under certain circumstances, no entries were displayed on the service task overview page. The pager was not displayed for exactly 21 hits in the member list of an Active Directory group. As a result, navigation to the 21st hit was not possible in this case. On the work list for the License Maintenance Assistant, inactive licenses are hidden, and the "Upgradeable" box can no longer be clicked. Business logic The maximum length of product names has been increased to 256 characters so that even very long names from the product catalog are no longer truncated. Under certain circumstances, downloading a document version via the Spider API interface could fail. Under certain circumstances, recurring reminders (resubmissions) were only sent on the second shipping date. If an employee initially supplied by Active Directory is no longer delivered to Spider, it was not marked correctly. In the very long synchronization processes between Software Services and Spider Asset, changes made to the asset in the meantime could be overwritten. Under certain circumstances, tasks for resubmissions could not be created automatically (function not available in all editions). Configuration For newer search pages, the MaxRows setting in the configuration is no longer supported. Obsolete configuration keys have been removed. The active control of tiles in the task dashboard has meanwhile been omitted and has been added again. The "AvailableFrom" and "AvailableTo" fields have been removed from Volume Licensing agreements. Spider application database names can now have a length of up to 128 characters. ... View more

With Spider 6.4.8, a new quick search functionality in Spider is introduced. The feature is a fully integrated search engine based on the Microsoft SQL Server Fulltext feature. It enables the fast finding of objects (in several types) in the Spider application suite. The following object types are indexed and can therefore be found with the feature: Article, Asset, Catalog article, Contract, Contractor, Employee, Function unit, License, and Manufacturer. 👆  The former index-based search (OneSearch) is replaced by the new functionality and will be removed with the update to Spider 6.4.8. Reachability The index-based search is reachable in most of the Spider application forms on the top right of each page. Please see the magnifier icon and click on it to open the search box. Search Result The search results are displayed grouped by type. The hits within their groups are displayed as hyperlinks that lead to the detail page of the indexed object. For performance reasons, the display of results per object group is limited to 150,000 hits. If this limit is exceeded, a message is issued (in this example for catalog articles). To get more specific results, the query has to be qualified by additional search terms. Search Logic The index-based search allows to show results by using single words as well as with the combination of multiple search terms. Therefore, the feature follows these rules: Operators By default, given search terms will be combined following the logic of AND. The index-based search also supports the operators OR and NOT. 👆  Operators must not appear at the beginning of a search query, as they must combine two search terms. Otherwise, an internal error occurs. Operator Description AND All given search terms have to be matched in the indexed object to be displayed as search result. OR At least one of the given search terms has to be matched in the indexed object to be displayed as result. AND NOT If the given search term matches, the indexed object will be excluded from the result. Word breaking By default, Microsoft SQL Server using characters like dots and hyphens as word breakers. For example, "company-device-333" would be found by searching for "device" as well as "device" and/or "333". Specific fields like hostnames contain those characters in their actual names. To be able to search for specific names, the index functionality replaces those characters internally. Therefore, hostnames can be found by their specific names. Type filters By using type filters, the search result can be limited to a specific type. This is done by typing the object type followed by a colon, a space character, and the search term, e.g.: manufacturer: microsoft Supported type filters Type Filter Article article: Asset asset: Catalog article catalogarticle: Contract contract: Contractor contractor: Employee employee: Function unit functionunit: License licence: Manufacturer manufacturer: Requirements & Configuration To get the new feature up and running, following steps should be considered: The SQL Server Fulltext feature is installed and enabled There is sufficient disk space available on the system (10 Gigabyte recommended) Feature is activated in the Spider configuration (disabled by default) Feature is activated in mandator details (enabled by default) The index has been created and is up to date To support the configuration of the index-based search, an administrative page has been added to the Spider user interface. It is available through the Spider main menu via System > Information about index.                     Furthermore, the feature will be enabled in the details page of the mandator. Here, the tab page "Index-based search" has been added.   ... View more

The November 2022 update of the Spider Software Services version 1.2211.1.2039 is now available. All components are available in our Product and License Center. Recognition Catalog The Recognition Catalog contains normalization and recognition capabilities for more than 2.898.096 inventoried programs 129.271 software publisher 6.942.620 inventoried files For more details please check the change notes. Software and SKU Catalog The Software Catalog contains more than 1.162.319 relevant and normalized articles (SKUs) of software licenses and maintenances and more than 70.225 license-relevant product versions. Summary of the supplemented catalog items: Articles (SKUs): 4.154 Versions: 285 Spider Data Collector The Spider Data Collector (SDC) provides a set of connectors to 3rd party inventory for an out-of-the-box collection of computers, software, users, virtualization, and many more. Please check the Spider Data Collector User Manual for a full reference of all connectors. ... View more

The October 2022 update of the Spider Software Services version 1.2210.1.2021 is now available.  All components are available in our Product and License Center. Highlights Version 3.0 of "Beitrittsvertrag EES Bundescampus" added, including appropriate LMPs. Corrections vCenter Connector: The treatment of IP addresses in hostnames has been improved. Recognition Catalog The  Recognition Catalog contains normalization and recognition capabilities for more than 2.895.882 inventoried programs 129.267 software publisher 6.928.262 inventoried files For more details please check the change notes. Software and SKU Catalog The Software Catalog contains more than 1.161.059 relevant and normalized articles (SKUs)  of software licenses and maintenances  and more than 70.043 license-relevant product versions.  Summary of the supplemented catalog items: Articles (SKUs): 3.706 Versions: 382 Spider Data Collector The  Spider Data Collector (SDC) provides a set of connectors to 3rd party inventory for an out-of-the-box collection of computers, software, users, virtualization, and many more. Please check the Spider Data Collector User Manual for a full reference of all connectors. ... View more

The September 2022 update of the Spider Software Services version 1.2209.1.2002 is now available.  All components are available in our Product and License Center. Catalog Changes Parts of McAfee Products have been moved to manufacturer Trellix Added Adobe Single Apps, including licence metrics procedures Added Adobe products for China region Nutanix Connector BETA A Beta version of a connector to Nutanix systems will be delivered with the September release of Software Recognition. The connector can be found beneath the installation folder of the Spider Data Collector. Recognition Catalog The  Recognition Catalog contains normalization and recognition capabilities for more than 2.891.798 inventoried programs 129.264 software publisher 6.909.233 inventoried files For more details please check the change notes. Software and SKU Catalog The Software Catalog contains more than 1.157.459 relevant and normalized articles (SKUs)  of software licenses and maintenances  and more than 69.559 license-relevant product versions.  Summary of the supplemented catalog items: Articles (SKUs): 6.932 Versions: 71 Spider Data Collector The  Spider Data Collector (SDC) provides a set of connectors to 3rd party inventory for an out-of-the-box collection of computers, software, users, virtualization, and many more. Please check the Spider Data Collector User Manual for a full reference of all connectors. ... View more

Spider enables the user to handle documents, including document versions in Spider. In some scenarios, the migration of documents to another apllication might be useful, for example if a document management system should be connected. To export all documents out of Spider, a Linq script has been developed. This will be connected to a Spider application database and will store all available documents to a local (Windows) folder.  The created structure will follow this schema DatabaseName > Mandator > ObjectType > ObjectIdentifier > DocumentFolder > FileName Warning: Use at your own risk. The script is free of use as is, but no warranty is given. No liability is assumed. To execute the script, the tool LinqPad can be used. LINQPad is not just for LINQ queries, but any C#/F#/VB expression, statement block or program. Put an end to those hundreds of Visual Studio Console projects cluttering your source folder and join the revolution of LINQPad scripters and incremental developers.  -   https://www.linqpad.net/ Consideration Please consider and execute the following steps to export the documents: Make sure you have enough local disk space. Depending on the number and the size of documents stored in the Spider database, the exported documents might need plenty of space. Download and install LinqPad. In our test, we've used LinqPad 5, which is free. https://www.linqpad.net/Download.aspx Open the script in LinqPad Configure the connection and the script Execute the script and monitor the progress. After hitting the green Play button, the progress will be shown in the results window (at the bottom of the application) Configuration After installing LinqPad and opening the script, please configure to application as follows: Create a connection to the SQL server on which the Spider databases are located. The user should have read permission to the database, updates will not be performed.  Set the Language to "C# program". Select the database you'd like to export documents from. All Spider 6.4 application databases are supported. If you'd like to download documents from multiple databases, you have to execute the script for each database. Type in the local root folder for the exported documents. The Script Download the script here: https://community.flexera.com/xtqzp85664/attachments/xtqzp85664/Spider-Knowledge/181.7/2/Export Spider documents.zip  Or copy the source code to LinqPad from here:     void Main() { /************************************************************************* This script exports all documents of a Spider database ************************************************************************* This script will create a directory structure as follows per document: Database > Mandator > ObjectType > ObjectIdentifier > DocumentFolder > FileName The file name will be formed from the document name, followed by the version in square brackets. Illegal characters will be replaced. /* SETTINGS *************************************************************************/ // Folder where the files should be placed string baseFolder = @"D:\_Temp\Documents Export"; // Illegal characters in document names will be replaced with this char char replaceInvalidCharsWith = '_'; /*************************************************************************/ var context = this; var bar = new Util.ProgressBar("").Dump(); var nOfNText = new DumpContainer().Dump(); var spacer = new DumpContainer().Dump(); var fileNameText = new DumpContainer().Dump(); var saveToText = new DumpContainer().Dump(); nOfNText.Content = "Determing meta data..."; Thread.Sleep(1000); var metaQuery = from doc in Document_base_M join mandator in Core_Mandator_01 on doc.MandatorID equals mandator.ID join sco in SCObjects on doc.SCObjectID equals sco.ID join docVersion in DocumentVersions on doc.ID equals docVersion.DocumentID join store in Storages on docVersion.StorageID equals store.ID join folder in Folders on doc.FolderID equals folder.ID select new MetaData() { BaseFolder = baseFolder, MandatorID = doc.MandatorID, Mandator = doc.Mandator, DocumentID = doc.ID, StorageID = store.ID, SCObjectName = sco.Name, Folder = doc.Folder.Replace("/", @"\"), ContractIdentifier = doc.ObjectIdentifier, FileName = doc.Name + " [v" + docVersion.Version + "]" + docVersion.FileType }; float i = 1; float all = metaQuery.Count(); string invalid = new string(Path.GetInvalidFileNameChars()) + new string(Path.GetInvalidPathChars()); string dbName = this.Connection.Database; foreach(var meta in metaQuery){ foreach (char c in invalid) { meta.Mandator = meta.Mandator.Replace(c, replaceInvalidCharsWith); meta.SCObjectName = meta.SCObjectName.Replace(c, replaceInvalidCharsWith); if(!string.IsNullOrEmpty(meta.Folder) && c != '\\') meta.Folder = meta.Folder.Replace(c, replaceInvalidCharsWith); meta.ContractIdentifier = meta.ContractIdentifier.Replace(c, replaceInvalidCharsWith); meta.FileName = meta.FileName.Replace(c, replaceInvalidCharsWith); dbName = dbName.Replace(c, replaceInvalidCharsWith); } bar.Percent = (int)((i/all)*100); bar.Fraction = i/all; nOfNText.Content = i + " / " + all; fileNameText.Content = "File name: " + meta.FileName; saveToText.Content = "Save to: " + meta.BaseFolder + @"\" + dbName + @"\" + meta.Mandator + @"\" + meta.SCObjectName + @"\" + meta.ContractIdentifier + @"\" + meta.Folder; var filePath = meta.BaseFolder + @"\" + dbName + @"\" + meta.Mandator + @"\" + meta.SCObjectName + @"\" + meta.ContractIdentifier + @"\" + meta.Folder + @"\" + meta.FileName; if(!File.Exists(filePath)){ Directory.CreateDirectory(meta.BaseFolder); Directory.CreateDirectory(meta.BaseFolder + @"\" + dbName); Directory.CreateDirectory(meta.BaseFolder + @"\" + dbName + @"\" + meta.Mandator); Directory.CreateDirectory(meta.BaseFolder + @"\" + dbName + @"\" + meta.Mandator + @"\" + meta.SCObjectName); Directory.CreateDirectory(meta.BaseFolder + @"\" + dbName + @"\" + meta.Mandator + @"\" + meta.SCObjectName + @"\" + meta.ContractIdentifier); Directory.CreateDirectory(meta.BaseFolder + @"\" + dbName + @"\" + meta.Mandator + @"\" + meta.SCObjectName + @"\" + meta.ContractIdentifier + @"\" + meta.Folder); var dataQuery = from store in Storages where store.ID == meta.StorageID select store.Data; var result = dataQuery.Single(); var bytes = result.ToArray(); File.WriteAllBytes(filePath, bytes); } i++; } nOfNText.Content = "Finished"; fileNameText.Content = all + " documents have been downloaded to"; saveToText.Content = baseFolder; } class MetaData { public string BaseFolder { get; set; } public int MandatorID { get; set; } public string Mandator { get; set; } public int DocumentID { get; set; } public int StorageID { get; set; } public string SCObjectName { get; set; } public string Folder { get; set; } public string ContractIdentifier { get; set; } public string FileName { get; set; } }     ... View more

Spider 6.4.7-R2 update is available Release Date: 2022-09-09 A new update has been released for Spider. Please see the included changes below.  To be notified of these kinds of product updates, please ensure that you have subscribed to the Spider Release blog. Improvements Search queries that are persisted via the "My search" Dialog now also save global filters. This is a change in behavior, previously global filters such as those for legal entities were not saved. Global filters will be applied for the user session when such a view is loaded. Other set global filters will be discarded. Screen reader support has been improved The keyboard navigation for the language selection has been revised Corrections Refreshing the details page of a license metrics procedure led to an error. Under certain circumstances, two consecutive calendar controls could lead to a display error. The export function on the search page for cloud subscriptions did not work. Due to an error, the location control only displayed the first address line. Due to an error, the table from a dialog was displayed on the details page for an asset. The License metrics procedure "User based" contained a typo in the word "calculation". ... View more

The August 2022 update of the Spider Software Services version 1.2208.1.1988 is now available.  All components are available in our Product and License Center. Changes Data connectors now support TLS, TLS 1.1, TLS 1.2 and SSL 3.0. Following connectors have been extended: Adobe Cloud Connector Microsoft Active Directory Connector Microsoft App-V Connector Microsoft Azure Connector Microsoft Exchange Connector Microsoft Graph Connector Microsoft Hyper-V Connector Microsoft Intune Connector Microsoft LDAP Connector Catalog Changes Additional LMPs for Adobe Bundles added. Missing release/maintenance/extended support dates for Microsoft product versions added. Recognition Catalog The  Recognition Catalog contains normalization and recognition capabilities for more than 2.880.775 inventoried programs, 127.687 software publishers, and 6.891.536 inventoried files. For more details please check the change notes. Software and SKU Catalog The Software Catalog contains more than  1.148.833 relevant and normalized articles (SKUs)  of software licenses and maintenances  and more than 69.300 license-relevant product versions.  Summary of the supplemented catalog items: Articles (SKUs): 2.782 Versions: 186 Spider Data Collector The  Spider Data Collector (SDC) provides a set of connectors to 3rd party inventory for an out-of-the-box collection of computers, software, users, virtualization, and many more. Please check the Spider Data Collector User Manual for a full reference of all connectors. ... View more

The July 2022 update of the Spider Software Services version 1.2207.1.1972 is now available.  All components are available in our Product and License Center. Changes Under certain circumstances, an incorrect classification in the software catalog could have led to overwriting a user defined classification. This has now been fixed. Catalog Changes Software patterns for ETAS Software patterns for Trimble Software patterns for NCH Software patterns for RIM Recognition Catalog The  Recognition Catalog contains normalization and recognition capabilities for more than 2.861.541 inventoried programs, 123.638 software publishers, and 6.868.264 inventoried files. For more details please check the change notes. Software and SKU Catalog The Software Catalog contains more than  1.147.800 relevant and normalized articles (SKUs)  of software licenses and maintenances  and more than 69.300 license-relevant product versions.  Summary of the supplemented catalog items: Articles (SKUs): 1.029 Versions: 457 Spider Data Collector The  Spider Data Collector (SDC) provides a set of connectors to 3rd party inventory for an out-of-the-box collection of computers, software, users, virtualization, and many more. Please check the Spider Data Collector User Manual for a full reference of all connectors. ... View more

Spider 6.4.7-R1 update is available Release Date: 2022-07-05 A new update has been released for Spider. Please see the included changes below.  To be notified of these kinds of product updates, please ensure that you have subscribed to the Spider Release blog. Corrections  Under certain circumstances a license could not be deleted if it was assigned to an article. Due to an incorrect implementation, the search page for cloud subscriptions could only be accessed with metering switched on. ... View more