Activity for HP-AssetManager Interface SQLs
-
w5base committed [3a7e03] on Code
add iassignment interpreation on l0_system
-
add iassignment interpreation on l0_system
-
add amtsiservicetype.bMonthly to servcies view
-
Larissa Fährmann committed [219f9d]
Erlaubt dem CSS.T-COM Schnittstellen-User die ausgewählten aktiven CIs von CustomerLink = DTAG INBOUND TELIT abzufragen
-
add amAsset.dSchedRetire for Incident IM0036297913
-
add new column name as "servicename"
-
add field prodcomp in AMIO.appl as view to amtsicustappl.prodcomponent to allow SAP Instance application migration to darwin - based on a Mail-Request from 15.02.2021 to Larissa
-
fixup Asset visibility only based on iassigmentgroup
-
add "isApplRelDisallowed" in system view
-
add systemid,systemname and usage to autodiscipaddress
-
allow view of ALL loadbalancers autodiscovery data and add field useage in autodiscsystem view
-
Merge branch 'master' of https://git.code.sf.net/p/hpam/code
-
allow view of ALL loadbalancers autodiscovery data and add field useage in autodiscsystem view
-
Larissa Fährmann committed [b320ff]
IM0031772836: Add the field nature into 110.asset.sql
-
Faehrmann Larissa committed [33db9d]
test
-
add Withdrawn_support based on Incident Request IM0029124444
-
add nature=APPLIANCE to SharedNetwork View
-
remove bdelete=1 Autodiscovery entires while calculation of sharednetwork items
-
remove application-system relations with bactive=0 from considering in acl calc
-
change blacklist in netnature restirction to whitelist 'FC-SWITCH','SWITCH','ROUTER'
-
fix ORA-01792 - max number of columns problem - SQL Hint 17376322:OFF
-
allow access for ifusers to systems on which the ifuser have (read) access to sender/reciver costelement of services on the system (based on Incident IM0027150907)
-
add bDataCenter flag to location view
-
add flag "isProtectedNetworkDevice" - fix nature/model handling
-
add flag "isProtectedNetworkDevice" to mark systems for which it is not allowed to create application relations
-
add new field Aperture_Status to fix location handling based on https://darwin.telekom.de/darwin/auth/base/workflow/ById/15529967930001
-
workaround to filter buggy fixedasset records while calcunlation of residualvalue
-
add ExternSystem and ExternalID to ipaddress view based on https://darwin.telekom.de/darwin/auth/base/workflow/ById/15396810370011
-
fix Calculation of residualvalue in 011.assetdepr.sql based on https://darwin.telekom.de/darwin/auth/base/workflow/ById/15407985060001
-
remove some ClusterIDs in system_acl_l1
-
reduce SystemIDs shown in system_acl_l0 to get a better restriction on AMIO.LISTENER_SYSTEM
-
add costcenter and sender_costcenter to service view
-
extend asset view to see assedids of complete farm, if one of logical systems on a itfarm is visible for ifuser
-
split itfarm complex in an global_* and dataaccess part, to get nativ (not for ifusers) access to itfarm information structures
-
add AMIO.listner_* interface, to allow database users (interface-users) to view, what other ifusers can "see"
-
fix information behind field "replkeysec" in view lnkschain
-
Faehrmann Larissa committed [87a19e]
IM0021800016: the iface_acl table has been enhanced with the parameters (CustomerLink) for the DTAG.MU customer
-
fix bdelete on lnkapplsystem
-
fix asset_deprend calculation based on https://darwin.telekom.de/darwin/auth/base/workflow/ById/15275967650001
-
Faehrmann Larissa committed [73fca3]
Korrektur Zeilenumbrüche
-
Revert "RRM-20180159: SAS70relevant field in system view and SlotNo in asset view"
-
fix Revert "RRM-20180159: SAS70relevant field in system view and SlotNo in asset view"
-
Faehrmann Larissa committed [938486]
RRM-20180159: updated backup_acl, removed join on system view
-
Faehrmann Larissa committed [a56d4a]
RRM-20180159: SAS70relevant field in system view and SlotNo in asset view
-
xxx
-
modify sclocation filter from 1* to not 8*/S* based on https://darwin.telekom.de/darwin/auth/base/workflow/ById/15199151030009
-
-
-
Cleanup test Note in README.md
-
Fährmann Larissa committed [d43318]
Test is done
-
Fährmann Larissa committed [f5fc2c]
Merge branch 'master' of https://git.code.sf.net/p/hpam/code
-
Fährmann Larissa committed [bfcfe0]
Larissas Git-Test
-
Fährmann Larissa committed [a36c04]
Larissas Test
-
Fährmann Larissa committed [1e2634]
Larissas Test2
-
create asset_acl_0 to get better performance on asset items
-
filter invalid fixedasset records in depreciation calculation view
-
remove cartesan product and add NO_MERGE hint to optimize query performance
-
change ipaddress_acl to use system_acl instead of system to get better query performance
-
add locationlocation on system view to reduce subselect calls in application layer
-
better handling for lnkapplsystem_acl and add NO_MERGE hint
-
prevent MERGE of huge views by adding hint to get better query performance
-
remove cartesan product and add NO_MERGE hint to optimize query performance
-
remove cartesan product
-
prevent MERGE of huge views by adding hint to get better query performance
-
add "lcomputerid" to service view because joins on lcomputerid are faster then joins on systemid (performance optimization)
-
remove cartesan product to optimize query performance
-
move calculation of asset age from w5base perlcode to sql in database. add a helper view assetdepr to get better readable statements
-
-
-
add assetid in SYSTEM view to reduce subsqls
-
Larissa Beschriftung
-
Cleanup
-
xxx
-
sdf
-
sTest
-
extend README.md
-
extend README.md
-
extend README.md
-
store readme on a better place
-
add README.md
-
fix for "Incident-Assignmentgroup with iface_acl" based on Larissas optimizations
-
add location informations to "SYSTEM" and "ASSET" and fix "deleted" flag in "SYSTEM"
-
remove insert samples for TEL_IT and add DTAG.SHARED customerlink
-
Merge branch 'master' of https://git.code.sf.net/p/hpam/code
-
fix missing "lassetid" in fixedasset view
-
TestPatch von Windows
-
add Incident-Assignmentgroup handling to iface_acl and (1st step) to asset_acl
-
Split AMIO.interface.sql in seperate files
-
x
-
-
Initial commit
1