add iassignment interpreation on l0_system
add iassignment interpreation on l0_system
add amtsiservicetype.bMonthly to servcies view
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
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
add Withdrawn_support based on Incident Request IM0029124444
add nature=APPLIANCE to SharedNetwork View
remove application-system relations with bactive=0 from considering in acl calc
remove bdelete=1 Autodiscovery entires while calculation of sharednetwork items
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
fix bdelete on lnkapplsystem
fix asset_deprend calculation based on https://darwin.telekom.de/darwin/auth/base/workflow/ById/15275967650001
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"
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
create asset_acl_0 to get better performance on asset items
filter invalid fixedasset records in depreciation calculation view
change ipaddress_acl to use system_acl instead of system to get better query performance
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
better handling for lnkapplsystem_acl and add NO_MERGE hint
prevent MERGE of huge views by adding hint to get better query performance
add assetid in SYSTEM view to reduce subsqls
remove cartesan product and add NO_MERGE hint to optimize query performance
-
add locationlocation on system view to reduce subselect calls in application layer
remove cartesan product
remove cartesan product and add NO_MERGE hint 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
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
start state of prod revision from 09.06.2017
start state of prod revision from 09.06.2017
create of release branch
optimize W5Replicate
try to fix latenz problems with slow dataobject...
new calculation of phaselimits
fix W5Replication if phaselimit is reached in s...
fix W5Replication if phaselimit is reached in s...
standard disable compatibility mode in IE
add explaination for the Minus Problem
remove double UTF8 quoting in SOAP Interface
fix to handle Forum-Mails with more then 1000 h...
fix Limit handling on W5Replicate on New Objects