cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Data from removed Data Sources still exist in BDNA_Publish and is used by FNMS DataPlatform Adapter

Hi @ll,

while testing the system and learn how it works, I've remove all FNMS data sources from BDNA Admin Console and run a normalization. (only 2 SCCM sources are added as inventory sources for BDNA).

Running the FNMS ComplianceReader DAtaPlatform Computer.xml in SQL Mgmt Studio, I realized that Normalized data from already removed data is still available in BDNA_Publish and should be imported into FNMS.

Based on this query, the FNMS Data Platform Adapter, builds his list of valid data sources (TaskDetails.xml)

IF OBJECT_ID('tempdb..#TASK_DETAILS') IS NOT NULL
DROP TABLE #TASK_DETAILS
CREATE TABLE #TASK_DETAILS(
TASK_ID numeric(18,0),
INVENTORY_ID numeric(18,0),
UNIQUE_ID varchar(200),
PRIMARY KEY(TASK_ID, INVENTORY_ID)
)
INSERT #TASK_DETAILS
SELECT TASK_ID, INVENTORY_ID, CAST(PROCESS_ID AS varchar(20)) + '|' + LEFT(dmt.TASK_NAME, 160) + '|' + CAST(CHECKSUM(dmt.TASK_NAME) AS varchar(11))
FROM MATCH_TASK_DET dmt
WHERE INVENTORY_ID IN (SELECT MAX(INVENTORY_ID) FROM MATCH_INVENTORY GROUP BY PROCESS_ID) 
SELECT * FROM #TASK_DETAILS

 

The out is 3 sources while having added only two sources in BDNA

2019-10-22 13_58_45-DFNM110DE on esx022.sl.softline.de (Work Resources).png

 

2019-10-22 13_59_24-DAPPPORTAL103EN on esx022.sl.softline.de (Work Resources).png

Looking forward to your feedback, Thanks and Best, Dennis

(1) Solution

@dennis_reinhardt 

 

In the Admin Console, go to the inventory icon in the top right. There you will see all the jobs. Delete the old process data set and it will remove it from Publish.

-Jason

Jason Lilleboe
Team Lead, Solution Engineering
Flexera

View solution in original post

(1) Reply

@dennis_reinhardt 

 

In the Admin Console, go to the inventory icon in the top right. There you will see all the jobs. Delete the old process data set and it will remove it from Publish.

-Jason

Jason Lilleboe
Team Lead, Solution Engineering
Flexera